Forum Discussion
Blank Measure if Unrelated Dim Tables are selected
Hey, Hoping to get some thoughts on whether it is possible to error out a measure which dim from an unrelated table is selected? See below what i'm currently trying to impliment: A Measure w...
Hello Anonymous ,
yes you can do inverse it like this
if(isfiltered(DimTable[field]) , yourmeasure,blank)so you put the blank if non of the filters you want to filter with is selected.
Hello Anonymous ,
so you use in the measure as following
if(isfiltered(DimTable[field]) ,blank, yourmeasure)
That works perfectly! Thank you.
Final question though: is there a way to inverse this? i.e. if any tables other than tables X and Y are selected then Blank?
Hello Anonymous ,
yes you can do inverse it like this
if(isfiltered(DimTable[field]) , yourmeasure,blank)so you put the blank if non of the filters you want to filter with is selected.