Counting all selection filters but one

[RobinQ]

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.

[_AAndrade · Accepted solution]

Hi,

You can try to use REMOVEFILTERS function, like this:
CALCULATE(
DISTINCTCOUNT(Orders[Order]),
REMOVEFILTERS('Name of the column of periods')
)

[RobinQ]

Hi _AAndrade, this is exactly what I was looking for. Thank you very very much!