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

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

  • Sportily's avatar
    Sportily
    Frequent Visitor
    4 years ago

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