IF with Isfiltered DAX Measure not return expected result when no filter is selected

[Anonymous]

Hi Experts

The following measure works fine when a filtered is selected that comes from dev_shc_shingrix_activity and and also works fine when a filter is selected from shc_shingrix_practice. However when no filter is selected is dose not give the correct result~

Measure

Shingrix Activity = IF(ISFILTERED(dev_shc_shingrix_activity),[Shingrix_],IF(ISFILTERED(shc_shingrix_practice),[Shingrix],[Shingrix_]))+0

[amitchandak · Accepted solution]

@Anonymous , try like

IF(calculate(ISFILTERED(dev_shc_shingrix_activity), allselected()),[Shingrix_],
IF(calculate(ISFILTERED(shc_shingrix_practice), allselected()),[Shingrix],
[Shingrix_Test]))+0

[Anonymous]

Thank you Amit