Forum Discussion
Solved
Rank x
Hi All, Measure 12 = CALCULATE(RANKX(ALL('Emporia Devices'[Device name KP]),CALCULATE(SUM('Emporia Device Usage'[Usages KWH])),,DESC,Dense)) Count of Rank 1 = CALCULATE...
Not sure how this is any better?
Thank @lbendlin for your prompt reply.
Hi JamesBurke ,
Depending on the information you have provided, I created a sample data to help you with your problem. You can follow these steps below.
Add new measures:
Count of Rank 2 =
VAR _count2 =
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[Measure 12] = 2 ) )
RETURN
IF ( _count2 <> BLANK (), _count2, 0 )
Count of Rank 3 =
VAR _count3 =
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[Measure 12] = 3 ) )
RETURN
IF ( _count3 <> BLANK (), _count3, 0 )
Count of Rank 4 =
VAR _count4 =
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[Measure 12] = 4 ) )
RETURN
IF ( _count4 <> BLANK (), _count4, 0 )
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.