Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to compare two Rows value in same table and assign a value in a separate column based on it

Hi Team,   I need help in below logic:   I have three tables: Orders table (Contains 1 row per orders placed with customer and revenue data as whole) Order line items table (Contains brief Orde...
DAX
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Please use

    Column = 
VAR Brand = CALCULATE ( SELECTEDVALUE ( 'Order Line Items'[Brand] ) )
RETURN
    IF ( 
        ISBLANK ( Brand ),
        "Mixed Order",
        Brand
    )

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 
Please use

Column = 
VAR Brand = CALCULATE ( SELECTEDVALUE ( 'Order Line Items'[Brand] ) )
RETURN
    IF ( 
        ISBLANK ( Brand ),
        "Mixed Order",
        Brand
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you tamerj1 , this solution worked.