Forum Discussion
JamesBurke
Helper III
Helper IIIRank 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?
lbendlin
Super User
Super Userplease explain what you expect instead
JamesBurkeHelper III
Helper III
Expecting Rank 1 to have 4 values and them all be in Kp Henley 1 as it's the only one that has been ranked one.
At the Moment it is counting the 192 rows for all stores
Expected Result :
| Value | KP Black rod | KP Henley 1 | KPLymm | KP MMacclesfield |
| 1 | 0 | 4 | 0 | 0 |
| 2 | 1 | 0 | 3 | 0 |
| 3 | 3 | 0 | 0 | 0 |
| 4 | 0 | 0 | 0 | 4 |
Thanks , James.