Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Ture / False column with multiple conditions

Hey everyone,    Essentially, I'm trying to build all the following page filters into a single true/false column but I'm just failing each time with the mutiple conditions.  If the conditions are m...
  • AntrikshSharma's avatar
    AntrikshSharma
    5 years ago

    Anonymous  Let me know if this works:

     

    Column 2 =
VAR DateToday =
    TODAY ()
VAR Activities =
    COUNTROWS (
        FILTER (
            RELATEDTABLE ( Activites ),
            Activites[Column A] = FALSE ()
                && Activites[Column B] = TRUE ()
        )
    )
VAR Conditions =
    NOT ISBLANK ( Clients[PO Date] )
        && ISBLANK ( Clients[Activites NEW.System Code1] )
        && Clients[PO Date] < DateToday
        && Clients[PO Date] > DateToday - 6
        && ISBLANK ( Clients[Episode Start] )
        && NOT CONTAINSSTRING ( Clients[Programme Status], "Ended" )
        && Activities > 0
RETURN
    Conditions
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous  Let me know if this works:

 

Column 2 =
VAR DateToday =
    TODAY ()
VAR Activities =
    COUNTROWS (
        FILTER (
            RELATEDTABLE ( Activites ),
            Activites[Column A] = FALSE ()
                && Activites[Column B] = TRUE ()
        )
    )
VAR Conditions =
    NOT ISBLANK ( Clients[PO Date] )
        && ISBLANK ( Clients[Activites NEW.System Code1] )
        && Clients[PO Date] < DateToday
        && Clients[PO Date] > DateToday - 6
        && ISBLANK ( Clients[Episode Start] )
        && NOT CONTAINSSTRING ( Clients[Programme Status], "Ended" )
        && Activities > 0
RETURN
    Conditions
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Worked perfectly thank you.