Forum Discussion
Page filter: OR relating to multiple fields
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
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 )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.
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 ?
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.