Forum Discussion

Sportily's avatar
Sportily
Frequent Visitor
4 years ago

Page filter: OR relating to multiple fields

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 f...
Need Help
johnt75's avatar
johnt75
Super User
4 years ago

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's avatar
Sportily
Frequent Visitor
4 years ago

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's avatar
    johnt75
    Super User
    4 years ago

    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's avatar
      Sportily
      Frequent Visitor
      4 years ago

      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.