Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 19 | |
| 17 | |
| 11 |