Forum Discussion
Applying multiple row filters
Hello!
Simple question: But how do I apply multiple row filters?
I have a dataset in which groups are defined. So in the filter pane I can filter by "GroupA".
However for a specific scenario I would like to also show 1 person outside of this group. The problem is that I can't tell the filter pane to filter on both GroupA + name of that one person outside of this group (let's call him Peter).
Since I am using directquery I can only create a measure to circumvent this.
Test = IF(SELECTEDVALUE(Table[Group])="GroupA" || SELECTEDVALUE(Table[Name])="Peter" ,"Yes","No")
The issue is that I can't use this measure as a filter. It won't let me.
Anyone know what I can do different here?
Cheers,
Erik
1 Reply
- DataInsightsSuper User
Anonymous,
I was able to create a visual filter with a DirectQuery table using your DAX. Are you using the measure as a visual filter or a page filter? Measures can't be used as a page filter.