Multiple Slicers -- How to select Slicer to ignore remove

[carlol]

Three Slicers

1. Year
2. Quarter
3. Country

If I select all countries , 2021 Q1 Median is 75

If I select 1 country , (I want to igore this slicer) , it is 30 , ( I want to illustrate 75 regardless of country selection) but to still filter based on Date

I tried this but still illusrtates 30

CALCULATE ( MEDIAN ( vwKPIMedianDoorToCT[Minutes] ),ALLSELECTED (), DimDate) -- Add Date Table back in 

& 

CALCULATE ( MEDIAN ( vwKPIMedianDoorToCT[Minutes] ),REMOVEFILTERS(DimCountry[CountryID]))

[amitchandak]

@carlol , try like

CALCULATE ( MEDIAN ( vwKPIMedianDoorToCT[Minutes] ),all(DimCountry))

[carlol]

Orignal Measure

IF (

DIVIDE ( SUM ( DataCoverage[REG]), SUM ( DataCoverage[HIPE] ) ) >= 1,

1,

IF(

DIVIDE ( SUM ( DataCoverage[REG] ), SUM ( DataCoverage[HIPE])) = BLANK (),

0,

DIVIDE ( SUM ( DataCoverage[REG] ), SUM ( DataCoverage[HIPE]))

)

)

Dax to ignore Slicers Year , Quarter using ALL 

Still doest work 

Year = 2021

Qtr = Q2 

Still only returns 2021 Q2

Coverage% AllYears =

VAR Reg=Calculate(SUM ( DataCoverage[REG] ),ALL(DimDate))

VAR HIPE=Calculate(SUM ( DataCoverage[HIPE]),ALL(DimDate))

VAR Fig = Divide(Reg,HIPE)

Return

Fig

[v-yingjl]

Hi @carlol ,

Basically the measure should work when using ALL() to ignore the filters. Make sure the slicers you have used are from the DimDate table and consider whether there is any other relationships or other tables in the report to affect it.

If it still does not work, you can also consider sharing a sample data file without any sesentive information about this thread.

Attached with the test file which works fine in my side.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.