Forum Discussion
rsbin
5 years agoCommunity Champion
ToHecWithRankX
Good Evening Greg_Deckler ,
Attempting to understand and replicate your message using CountRows instead of RankX. However, having difficulty replicating the results shown in your message. I have recreated your 'Table' and copied your Measure3.
GroupItemValueToHellWithRankXDescMeasure3
| one | Item 1 | 700 | |
| one | Item 2 | 800 | |
| one | Item 3 | 900 | |
| one | Item 4 | 1000 | |
| Three | Item 10 | 12 | |
| Three | Item 8 | 200 | |
| Three | Item 9 | 1100 | |
| two | Item 5 | 500 | |
| two | Item 6 | 400 | |
| two | Item 7 | 300 |
ToHellWithRankXDescMeasure3 =
COUNTROWS(
FILTER(
SUMMARIZE(
FILTER(
ALL('Table'),
[Group] = MAX([Group])
),
[Item],
"Value",SUM('Table'[Value])
),
[Value]>=SUM([Value])
)
)
But I get a blank column. Unable to figure out where or what I am doing wrong. Hoping you can find or point out what I am missing.
Once I get this, then I hope to be able to subsitute my own values and add some additional complexities and scenarios that I need to account for in my data set.
Thanks in advance and Best Regards,
1 Reply
- Jihwan_KimSuper User