Forum Discussion
dinoscool3
Helper II
Helper IIShow Percentage of Matrix Rows above X
I have data with registrations for the past two years, each registration is attached to a group and I've created a matrix with how many registrations each group has. I want to see how many Groups...
Hi dinoscool3 ,
According to my understanding , you want to show how many organizations have more than 50 regsitrations,right?
You could try this:
CountFlag = IF( CALCULATE(COUNT('Table'[Email]),ALLEXCEPT('Table','Table'[Organization ]))>5,1,0)CountAbove50 = IF(ISINSCOPE('Table'[Organization ]),[CountFlag], CALCULATE(DISTINCTCOUNT('Table'[Organization ]),FILTER('Table',[CountFlag]=1)))The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashish_Mathur
Super User
Super UserHi,
Share some simple data, describe the question and show the expected result.
dinoscool3I'm having trouble posting so here's a screenshot of my reply.
- Ashish_Mathur