Forum Discussion
CountIFS With Multiple Criterion
Hi All, I want to use the CountIfs formula of Excel in Power BI for 3 criterias, which are Name, Company Name and Date. However, I am unable to do so in Power BI. I am using the following formula ...
I tried to Group By the columns : Name, Company and Date. In this however, the rows get reduced. So I was thinking if there is any formula to count the number of particular names?
Here, since there are 4 rows, it is dividing by 4. However, I want only 2 counts for Ash and 1 each for Josh and Ray respectively. Is there any method to perform this?
Kindly please help.
Thank you,
Regards,
Saumitra Upadhyaya