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.

dkaushik's avatar
dkaushik
Icon for Resolver II rankResolver II
5 years ago

Hi dinoscool3 ,

 

You can create a calculated column and assign 1 or 0 based on your criteria. Then create a measure to COUNT instead of SUM.

 

Hope this helps.

 

Thanks,

Dheeraj

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

    Hi! I've tried this too, but  I run into the same problem. I've already caluclated the 1 or 0 on my matrix, but it won't let me count a column made from a measure.