Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Stack Bar Chart not allowing me to Filter To N

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...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.