Forum Discussion

dinoscool3's avatar
dinoscool3
Icon for Helper II rankHelper II
5 years ago
Solved

Show 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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

dinoscool3's avatar
dinoscool3
Icon for Helper II rankHelper II
5 years ago

I'm having trouble posting so here's a screenshot of my reply.

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

You may download my PBI file from here.

Hope this helps.