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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey Antriksh Sharma, 

 

Thanks for your reply. 

 

If it's any help I'll update a sample PBIX file for you (onedrive link below). Essentailly, I need to create a calculated column on the "Clients" dataset which will result in "True" if all the conditions are met and "False if they are not". You'll see on the Power BI report below, that I've been able to create the conditions using Page/report level filters however, I really need this in a calculaed column. 

 

https://1drv.ms/u/s!AnIEh6WhI4JogvlY-yO3F1OBOLV-wQ?e=VF2V6g 

The conditions are 
* Clients "PO Date" is NOT blank 
* Clients "System Code1" IS blank
* Clients "PO Date" Is betwene today and the last 7 days
*Clients "Episode Start" IS blank
Clients "Programme Status" Does Not contain "Ended"
Activities "Column A" is False
Activites "Column B" is True.  


Thank you agian. 

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