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
Can you please explain this with some example? Also explain how and where you intend to use that column. Is it just a calculated column in a table?

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

      Worked perfectly thank you.