Page filter: OR relating to multiple fields

[Sportily]

Hi everyone.

Is it possible to apply a Page Filter which says:

Filter results, to show results where

This field = ANDY

OR

This other field = ANDY

I can do this when building a filter for a view in PowerApps, but not sure how to do it in a PowerBI visualisation sheet.

Thanks so much

Chris

[johnt75]

You would need to create a measure which returns 1 if either condition is met then use that as your page level filter

[Sportily]

Ah, ok, great shout, thank you.
Is it true that a measure can only be applied to a visual filter, not as a whole page filter?

I'm so newbie, but trying hard to learn.

I had a go with this, but its clearly not right. Is it too much to ask for a hint here, where you might just laugh at my attempt. 
THANK YOU

VAR result =

CALCULATE (

COUNTROWS ( cr715_session ),

cr715_session[cr715_primaryspacename] = "ENCOUNTER"

|| cr715_session[cr715_secondaryspacename] = "ENCOUNTER"

)

RETURN

IF (TRUE,1,0)

IF ( ISBLANK ( result ), 0, result )

[johnt75]

I think you may be right about the page level vs visual level filter with measures.

For the filter, try

IF ( SELECTEDVALUE( cr715_session[cr715_primaryspacename]) = "ENCOUNTER" || 
SELECTEDVALUE( cr715_session[cr715_secondaryspacename]) = "ENCOUNTER" , 1 )

[Sportily]

Thanks John,

Ok, thats alright, I can apply for each visual rather than the page.

Ah ok, I see. Thanks.

Measure gets a thumbs up, but when I apply it I think I'm doing it wrong.... I assumed I need to set it to 'is 1', is that not true? When I do it presents no data. Have I applied it wrong?

Sorry.

[johnt75]

No, that is correct. Is there a field on the visual which comes from the cr715_session table ? If so then that should be restricting the value of the spacename.

Is it possible to share a PBIX ?

[Sportily]

The data in the visual seems to be drawing from another table.

Can't share PBIX, sorry.

Don't worry though, you've been massively helpful and I'm going to keep investigating it and learning along the way.

Thank you.