Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Powerbi's world,
I have created a specific formula with rank and "TOP rank" segment.
I have also added a filter which is be able to exclude or not specific turn over (service fees).
1. First, I have created a rank formula :
And it works !
Next, i have created a "TOP RANK" with these mesure :
3. And next, this is more complicated, i need to apply this filter in segment (the aim is to subtract some services fees to the turnover) so i need to choose "non" :
When I have choosen "Non" (Services fees are excluded), the top rank doesn't work.
Questions are : Where I need to change the formula and how i can do it please ?
Thank you in advance for your help.
Léna
I think your last filter is in a separated table. If Yes,
Follow steps below:
1-Create a calculated column in your Table:
RELATED('TableName'[filtre frais Airport])
2-Then Put the calculated column in your Slicer.
Then it works as you expect.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |