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

 

 

  • 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
    )
)

4 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    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?