Forum Discussion

JustDavid's avatar
JustDavid
Icon for Helper V rankHelper V
1 year ago
Solved

How to compare column value to another column value via Measure

In a table of many columns, I created a calculated column 

 

 

IF(([column1]=[column2])*([column1]<>"")*([column2]<>""), "ReturnValue", IF([column1]<>"", "ReturnAnotherValue", BLANK()))

 

 

My question is, how can I achieve the same result as the calculated column but via a measure?

 

Tried the following dax, but gave me an error indicating "a table of multiple values was supplied where a single value was expected"

 

SWITCH(TRUE(),
        (VALUES(tbl[column1]) = VALUES(tbl[column2])) && (VALUES(tbl[column1]) <> BLANK()) &&  (VALUES(tbl[column2]) <> BLANK()), "ReturnValue",
        VALUES(tbl[column1]) <> BLANK(), "ReturnAnotherValue",
        BLANK()
    )
Need Help
Show and Tell
  • techies's avatar
    techies
    1 year ago

    Hi JustDavid 

     

    Please check this measure

     

    Test Measure =
    VAR SelectedValueA = SELECTEDVALUE('table A'[column1])
    VAR SelectedValueB = SELECTEDVALUE('table A'[column2])

    RETURN
    IF(
    NOT(ISBLANK(SelectedValueA)) && SelectedValueA = SelectedValueB,
    "ReturnValue",
    IF(
    NOT(ISBLANK(SelectedValueA)),
    "ReturnAnotherValue",
    BLANK()
    )
    )

1 Reply

  • techies's avatar
    techies
    Icon for Super User rankSuper User
    1 year ago

    Hi JustDavid 

     

    Please check this measure

     

    Test Measure =
    VAR SelectedValueA = SELECTEDVALUE('table A'[column1])
    VAR SelectedValueB = SELECTEDVALUE('table A'[column2])

    RETURN
    IF(
    NOT(ISBLANK(SelectedValueA)) && SelectedValueA = SelectedValueB,
    "ReturnValue",
    IF(
    NOT(ISBLANK(SelectedValueA)),
    "ReturnAnotherValue",
    BLANK()
    )
    )