Help with all pages filter usign or condition

[boscollo]

Dear,

I have a problem to resolve. All my fact are based in two different dimensions and I would like to filter all my pages with two possibilities in theses dimensions. I create a measure, but I can't filter with, at least I use this measure with the dimension data together. I will try to example: I want to do is filter my fact only with mouses or RedDragon products.

FilterMyProduct =  IF (OR(CONTAINSSTRING(SELECTEDVALUE(dim_type[type_name]),"mouse"),CONTAINSSTRING(SELECTEDVALUE(dim_brand[brand_name]),"redDragon")), "YES", "NOT")

If I use this in the filter, nothing happens.

Thanks in advance 

[Anonymous]

Noscollo,

You put in on the filter for all page. Just add it for the visual himself. You click on the visual and you will have filter only for this visual

[boscollo]

James, this is the problem.

I would like to reduce my dataset only for these products and to do this I need to use an "or" operation and power bi only permit "and" filters between different fields. 

[Anonymous]

HI @boscollo,

AFAIK, the default filter effects use AND logic to link each filter and you can't change it to OR logic.
The workaround is using a measure expression on the visual level filter to apply the filter effect but they were not able to be used on the report level.
For your requirement, I'd like to suggest you submit an idea to add support with OR logic filters.

Regards,

Xiaoxin Sheng

[boscollo · Accepted solution]

Xiaoxin, thanks for you reply.

In fact it is not possible to create OR conditions, the measure I can use only in visual content and this is not my case. What I want to do is constrain the dataset to a part of this.

The workaround that I did was create a table with the cartesian product with the dimension keys and the flag and use it to reduce my dataset,

Regards

[boscollo]

James, thanks for the try. But it doesn't work.
If I put the measure together the dimension fields, ok. But I am trying to filter all pages, dragging the measure in the filter column.

Regards

[Anonymous]

Hi

Try This

Measure=

if(or(SELECTEDVALUE(dim_type[type_name]) ="mouse",SELECTEDVALUE(dim_brand[brand_name])="redDragon"),"Yes","Not")