Forum Discussion

nelson777's avatar
nelson777
Frequent Visitor
4 years ago
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 ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    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
    )
)
nelson777's avatar
nelson777
Frequent Visitor
4 years ago

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?

 



tamerj1's avatar
tamerj1
Community Champion
4 years ago

nelson777 
Sure.
What is the code for duration?

  • nelson777's avatar
    nelson777
    Frequent Visitor
    4 years ago

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