topic Re: Ture / False column with multiple conditions in DAX Commands and Tips

Ture / False column with multiple conditions

Anonymous — Wed, 28 Oct 2020 16:41:43 GMT

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 met then True if not false.

Note. Client Sheet and some are are on the Activites sheet (related by client ID). and PO date rage filter is the last 7 days

Thanks in advance.

Re: Ture / False column with multiple conditions

AntrikshSharma — Wed, 28 Oct 2020 16:50:41 GMT

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

Re: Ture / False column with multiple conditions

Anonymous — Wed, 28 Oct 2020 17:41:44 GMT

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.

Re: Ture / False column with multiple conditions

AntrikshSharma — Wed, 28 Oct 2020 18:05:40 GMT

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

Re: Ture / False column with multiple conditions

Anonymous — Wed, 28 Oct 2020 19:12:17 GMT

Worked perfectly thank you.