Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I've created a dasboard with a few diagrams; orders by year, country and conversion time. The data is all stored in a single table. A measurement has been added so I can see the total count orders. When I select one or multiple bar charts, the whole page is filtered down to that data.
Now what I would like is to create a new measurement that can count the orders, but then without the selection filter for a specific diagram.
Data
Dashboard without selection (283 orders total)
Dashboard with "Italy", "2021" and "2022" selected (35 orders total)
Dashboard with "Italy", "2021" , "2022", "31-60" and "61-90" selected (19 orders total)
Now in the last image, I would like to get the order count which has been filtered in the Country and Year diagrams, without the filter of Days diagram. Then I can calculate the ratio within the conversion time chart, so value "35" (selection filter of country + year charts) and "19" (selection filter of country + year + conversion time charts), which should then be 19/35*100 = 54%.
Does anyone have any suggestions on how to approach this? I know about the DAX function ALL(), which ignores the selection of the whole page, but I need to only ignore the selection of a particular chart..
The calculation for all the orders is:
Order count = CALCULATE(DISTINCTCOUNT(Orders[Order]))
Thanks for taking the time to read this.
Solved! Go to Solution.
Hi,
You can try to use REMOVEFILTERS function, like this:
CALCULATE(
DISTINCTCOUNT(Orders[Order]),
REMOVEFILTERS('Name of the column of periods')
)
Proud to be a Super User!
Hi,
You can try to use REMOVEFILTERS function, like this:
CALCULATE(
DISTINCTCOUNT(Orders[Order]),
REMOVEFILTERS('Name of the column of periods')
)
Proud to be a Super User!
Hi _AAndrade, this is exactly what I was looking for. Thank you very very much!