topic Re: Calculation with true/ false statment in DAX Commands and Tips

Calculation with true/ false statment

nelson777 — Thu, 05 May 2022 05:19:25 GMT

Hi there,

I have a measure with a condition that returns me 1 for TRUE and 0 for FALSE.

What do I do, to sum up, all the 1 (True) results?

The condition works with this logic: if the amount of alerts is greater or equal to the number of devices, so it will count as 1.

then, my right outcome in the below example would be 2 as a result of the "Measure"

Re: Calculation with true/ false statment

tamerj1 — Thu, 05 May 2022 06:50:09 GMT

Hi nelson777
You may try

Measure1 = SUMX ( VALUES ( d_time[Hour Num] ), CALCULATE ( VAR Client = MAX ( d_clients[Client Full Name] ) VAR devices_per_client = CALCULATE ( DISTINCTCOUNT ( d_devices[Device] ), d_clients[Client Full Name] = Client ) VAR Alerts = CALCULATE ( [Alerts], VALUES ( f_alerts[Start Date] ) ) VAR Tag = IF ( Alerts >= devices_per_client, 1, 0 ) RETURN Tag ) )

Re: Calculation with true/ false statment

nelson777 — Thu, 05 May 2022 07:07:41 GMT

Hey, tamerj1 thank you very much!

I got to resolve that before you reply to me but in a different way. However, your solution is way cleaner than mine. lol

Would you mind helping me to figure now how to get the duration sum by obeying the same rules as before?

Re: Calculation with true/ false statment

tamerj1 — Thu, 05 May 2022 07:20:45 GMT

nelson777
Sure.
What is the code for duration?

Re: Calculation with true/ false statment

nelson777 — Thu, 05 May 2022 07:54:37 GMT

I worked it out. Thanks very much!!!!!