Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Only apply measure to specific rows

Hi, 

 

How would I create a measure that only applies [SAID_FORMULA] to {Specific Channel in Table}.. and applies a different [SAID_FORMULA2] to all else. 

  • Hi Anonymous,

     

    You can do something like this:

    FORMULA =
    IF (
        MAX ( Table[Specific Channel] ) = "Specific",
        SUM ( Table[A] ),
        SUM ( Table[B] )
    )

    Regards,

    MFelix

2 Replies

  • Hi Anonymous,

     

    You can do something like this:

    FORMULA =
    IF (
        MAX ( Table[Specific Channel] ) = "Specific",
        SUM ( Table[A] ),
        SUM ( Table[B] )
    )

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable

      Perfect! 

      Thanks!!