Forum Discussion
Solved
Power BI total Count for grouped value based on filter condition
Hello, I have a table named XYZ and columns A and B as below - A B Delhi 1 Delhi 2 Delhi 3 Mumbai 1 Jaipur 2 Jaipur 3 Hyderabad 1 Chennai 2 Nagpur 3 Nagp...
You can try this DAX to get your result:
Count_B_Greater_Than_1 = CALCULATE( COUNTROWS( FILTER( SUMMARIZE('Table', 'Table'[A], "Count_B", COUNT('Table'[B])), [Count_B] > 1 ) ) )Best Regards,
Muhammad YousafIf this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.
Thank you for helping so quickly 🙂 I really apreciate your efforts on this.