Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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