The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
20 | |
15 | |
14 | |
10 | |
7 |