Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

 
1 ACCEPTED SOLUTION
nandukrishnavs
Super User
Super User

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


Regards,
Nandu Krishna

View solution in original post

1 REPLY 1
nandukrishnavs
Super User
Super User

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


Regards,
Nandu Krishna

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.