Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Switch, value and result from a column

Hi guys,   I created a Report with a measure that returns different strings e.g. 1-2-3             2-4-1             I want to add a measure2 to that report that delivers me more information rel...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    Anonymous 

     

    Not sure about your existing data model.

     

    Try this 

    Measure2 =
VAR m1 = [Measure1]
VAR result =
    CALCULATE (
        SELECTEDVALUE ( 'Table1'[Information] ),
        'Table1'[Coordinates] = m1
    )
RETURN
    result

     

    If this is not working then please copy your sample tables and measures here.

     



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

Not sure about your existing data model.

 

Try this 

Measure2 =
VAR m1 = [Measure1]
VAR result =
    CALCULATE (
        SELECTEDVALUE ( 'Table1'[Information] ),
        'Table1'[Coordinates] = m1
    )
RETURN
    result

 

If this is not working then please copy your sample tables and measures here.

 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂