Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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.
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.
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |