Create filter/slicer by a rank

[Anonymous]

Hey there

I was wondering if we could use a dax ranking to create a slicer or use it as a filter. 

Context: I need to be able to select which value of the rank I want to slice a visual. I know we can create a measure and use it in card for a selected value in ranking (for intance, the second or the fourth one), but I need to use it as a filter/slicer in another visual.

Is is posible?

Thanks for your help!

[v-henryk-mstf]

Hi @Anonymous ,

First of all, you should know that measure doesn't support Slicer. If you want to use DAX to create rank functions, you can use calculated column, which supports slicer/filter.

Here is the sample pbix file.

Best Regards,
Henry

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

[Anonymous]

Hey!

I have a rank based on an average of our hourly productivity results, and I need it to be used as a slicer/filter for visuals other than a card. My expectation is to be able to select the number 3, for instance, in my slicer and all visuals in the dashboard would be filtered as the third in the ranking.

Am I clear enough? I could try to simulate it, if it helps.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[amitchandak · Accepted solution]

@Anonymous , You need to create an independent table and that you have use to filter RANK

Geography Rank = RANKX(all(Geography[City]),[Sales])

Assume you have independent table Rankno with column rankno

Rank Selected = sumx(filter(VALUES(Geography[City]),[Geography Rank]=selectedvalue(Rankno[Rankno ])),[Sales] )

or

Rank Selected = sumx(filter(VALUES(Geography[City]),[Geography Rank] in values(Rankno[Rankno ])),[Sales] )

Very similar concept to dynamic segmentation. Here each value is bucket (= not between)

https://www.youtube.com/watch?v=CuczXPj0N-k