Forum Discussion
Filter may have maxiumum two values selected
I have a filter on (let say) category: cat1 cat2 cat3 cat4 In this filter the user can only select one or two values. In this case it does not make sense to select more and one of my visua...
Can't you do a simple measure using a distinct count and then applying a filter
Visual filter = VAR vFilterCount = DISTINCTCOUNT(filterTable[filterColumn]) RETURN IF(vFilterCount <= 2;1;0)
Then apply a visual filter on the measure that it has to be 1
I'll try to find another solution. I want to make it as monkey proof as possible.
But thanks for your suggestion.
adambhappy
Resolver II
Resolver IICan't you do a simple measure using a distinct count and then applying a filter
Visual filter =
VAR vFilterCount =
DISTINCTCOUNT(filterTable[filterColumn])
RETURN
IF(vFilterCount <= 2;1;0)
Then apply a visual filter on the measure that it has to be 1