Forum Discussion

TSki's avatar
TSki
Regular Visitor
3 years ago
Solved

Top N slicer using measure

I am trying to make a sliding slicer off of this measure. I found this code from another user that, gives the TOPN for using COUNTROW to get the TOPN of the most repeated values.  Measure = VAR ...
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi TSki ,

     

    Unfortunately, you can't add measure to slicer. As an alternative, you can create a new column:

     

    TOPN = RANKX('Table',[The most repeated values],,DESC,Dense)

     

     

    I think this is pretty close to what you want:

     

    Or like this:

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi TSki ,

 

Do you want to count the number of the most most repeated values and then use it as slicer? If so, please try following steps.

 

This is my test table:

 

Create a new column instead of a measure:

 

The most repeated values = CALCULATE(COUNT('Table'[Category Level 1]),FILTER('Table','Table'[Category Level 1] = EARLIER('Table'[Category Level 1])))

 

 

Create a slicer using the column just created:

If I misunderstand your demands, please feel free to contact us in time.

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

TSki's avatar
TSki
Regular Visitor
3 years ago

Thanks for your reply v-yadongf-msft , 

With this new column, can I apply a TOPN measure to it and then apply to a slicer? Where a one on the slicer displays the most repeated value, 2 shows the top 2 most repeated values, and so on. So in your test data, when the slicer is slid to 1: B will be displayed and when slid 2: B and D are displayed, when on 3: B, D, E, A are displayed and on 4: B, D, E, A, C are displayed.