Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Show Only Specified RANK AND First and fifth

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 ha...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

 

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.