Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
So I used @Greg_Deckler 's quartile function from here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/QUARTILE/m-p/1064307
to create this measure in my report:
QUARTILE Orig =
VAR __Values = SELECTCOLUMNS('Quartile Table',"Values",[Revenue])
VAR __Quart = MAX('Quartiles'[Quart])
VAR __Median = MEDIANX(__Values,[Values])
VAR __Count = COUNTROWS(__Values)
VAR __Quartile =
SWITCH(__Quart,
0,MINX(__Values,[Values]),
2,__Median,
4,MAXX(__Values,[Values]),
1,
VAR __Median = IF(
ISEVEN(__Count),
MEDIANX(FILTER(__Values,[Values] < __Median),[Values]),
MEDIANX(FILTER(__Values,[Values] <= __Median),[Values])
)
RETURN __Median,
3,
VAR __Median = IF(
ISEVEN(__Count),
MEDIANX(FILTER(__Values,[Values] > __Median),[Values]),
MEDIANX(FILTER(__Values,[Values] >= __Median),[Values])
)
RETURN __Median
)
RETURN
__Quartile
I have a filter on the current page for another column in the Quartile Table called Supplier. When I filter for a particular supplier, the amounts for the above measure all simply return the same amount related to the supplier I selected which makes sense. I want to alter this measure so that when I filter for a supplier, it igornes the filter and returns the result for all suppliers instead.
I tried putting ALL('Quartile Table'[Supplier]) pretty much everywhere possible, but that didn't really give me the right result either.
This should be sufficient
VAR __Values = SELECTCOLUMNS(ALL('Quartile Table'),"Values",[Revenue])
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 66 | |
| 41 | |
| 39 | |
| 39 | |
| 39 |