Forum Discussion
Solved
Calculation with true/ false statment
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 ...
Hi nelson777
You may tryMeasure1 = 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 ) )
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
)
)
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?