Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
i have a simple Bar Chart that uses a Text and a Sum of a Number value. I wnat to filter down the top 5 values but it doesn't seem to be available in the drop-down.
Im open to any suggestion 🙂
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous,
To create a measure as below.
Measure = VAR ranksum = RANKX ( ALLSELECTED ( Table1[cate] ), CALCULATE ( SUM ( Table1[value] ) ) ) RETURN IF ( ranksum <= 5, CALCULATE ( SUM ( Table1[value] ) ), BLANK () )
For more details, please check the pbix as attached.
Regards,
Frank
Hi @Anonymous,
To create a measure as below.
Measure = VAR ranksum = RANKX ( ALLSELECTED ( Table1[cate] ), CALCULATE ( SUM ( Table1[value] ) ) ) RETURN IF ( ranksum <= 5, CALCULATE ( SUM ( Table1[value] ) ), BLANK () )
For more details, please check the pbix as attached.
Regards,
Frank
RankX work only once it gives rank as a static one time only ,ranks will not work if user applies any filter over data.rankx always give rank for whole table.
Hi @Anonymous,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |