How to use count rows function that will filter the dataset based on filter selection

Question

I have added parameters like date filed of from and to and one country filed and one language filed. Now i need a calculated column to be created where first column will give count where that count depends on parameters that user has selected. second column also a calculated column but here the Language is fixed to English , means that second calculated column take dates and region from parameter and fix language of english and give count in second column. It all dynamic table .

Answer 1

Hi @Anonymous

For information on how to use the CountRows function, you can refer to this link: CountRows function.

If you want to add a condition, such as "language = English", then you can consider using the Count function.

I did a simple test.

Preview

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya