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 ,
you can remove the interaction between the unrealated dim visuals and your main visual,
https://youtu.be/3cizrW4CKKQ?si=xUv9kbbOr9x1J5v8
Hey Idrissshatila, That would work if you were only the measure in a single visual, however, if you wanted to use the new cards feature then it wouldn't work as you may want to change the view of some values but this would then provide the wrong result