Forum Discussion
Solved
Filter not Filtering
I have a workbook with a slicer and 3 measures in it. I cannot share the real data, but it looks like this: KatA KatB Count Value Department 1 X 1 100 A 1 Y 1 200 A 0 X ...
Hi H3nning
Why is KatB using a different switch table? Also, I would use SELECTEDVALUE instead of VALUES as the latter returns a table instead of a scalar value - no problem if there is only one selection but will return an error if not. These aside, I can't replicate your issue. Your measure should work as intended.
Ok, I found a workaround, but it makes no sense to me:
I created a calculated column _KatB= IF(Table[KatB] = "X",1,0).
And when I use this field in the measure instead of KatB directly it works out fine. KatA is also a calculated field to be honest. So does it have to do with the fact that it is calculated or that it is a number, that it works that way??? Can anyone explain please?
THX!