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 related to that strings. 

Report:

Measure1 | Measure2

1-2-3            | Test123

2-4-1            | Test241

 

The information are written in a table

Table1:

Coordinates |Information

1-2-3            | Test123

2-4-1            | Test241

 

I could do it manually with a Switch like below, but I have more than 64 coordinates with different information. 

measure =
SWITCH(TRUE();
[Cube_coordinate] = "1-2-3"; "Test123";
[Cube_coordinate] = "3-2-1";"Test321"
)

 

How can I combine switch with a table for values and results? 

 

Thanks

BR

Chris

 
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     🙂

1 Reply

  • 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     🙂