Show Only Specified RANK AND First and fifth

[ouss1999]

Is someone has an idea on how we can display a table while only showing 3 rows ( first rank sthe rank of the seller we choose and fifth rank while showing only the name of the one we do choose)

i have been strugling with this task for a while

i did find a way to display all the seller while filtering by one seller and showing only his name( so whenever i choose a seller i have his name displaying now while the others remain X )

but i do only want the fifth and first place and the one i choose to show

Is there anyway to do that ?

[v-zhengdxu-msft · Accepted solution]

Hi @ouss1999 

Maybe you can try this:

First of all, I create a set of sample:

Then I add a measure to analog (whenever i choose a seller i have his name displaying now while the others remain X )

Next, add a measure:

Measure 2 = IF(MAX('Table'[Rank])IN{1,5}||[Measure]<>"X",1)

The result is as follow:

Best Regards

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