Forum Discussion

kilala's avatar
kilala
Resolver I
4 years ago
Solved

Conditional Calculation Based on Category

Hi all,    I have quite complicated logic that I need to apply.   In his scenario, I have table Brand with their revenue amount.    I need to re-allocate "Default" to brand where revenue > 0, e...
conditions
DAX
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, kilala 

     

    You can try the following methods.

    Measure =
IF (
    SELECTEDVALUE ( 'Table'[Brand] ) = "D",
    SELECTEDVALUE ( 'Table'[Amount] ),
    IF (
        SELECTEDVALUE ( 'Table'[Amount] ) > 0,
        -1000,
        SELECTEDVALUE ( 'Table'[Amount] )
    )
)

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kilala's avatar
kilala
Resolver I
4 years ago

Hi Anonymous ,

thank you for your suggestion, but currently i'm not able to add new column as i connect to live dataset. I can only create measures here. i think to use filter but it cannot return multiple columns. 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ok, Try it

Measure =
IF (
    SELECTEDVALUE ( 'Table (3)'[Brand] ) = "D",
    SELECTEDVALUE ( 'Table (3)'[Brand] ),
    IF (
        SELECTEDVALUE ( 'Table (3)'[Amount] ) > 0,
        "Default",
        SELECTEDVALUE ( 'Table (3)'[Brand] )
    )
)