Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • 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.