Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Invesco
Helper V
Helper V

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

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
 
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Invesco , try like

 

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Invesco , try like

 

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

Thank you Amit

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.