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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Show value text column if other column filtered

I have two columns in two different tables that are related to each other.

Column AColumn B
RedTest1
BlueTest2
YellowTest3
BlueTest4

 

I want to get Column B in to a measure and show it in to a table if for example Column A is "Blue". so i will get:

Column B
Test2
Test4

 

Could anyone help me with the right dax formula? i cannot do this in power query because this is data form azure analyses services.

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous ,

 

Since the connection mode is live connection, the only option in Power BI is to create multiple measures for each color.

 

Best Regards,

Jay

amitchandak
Super User
Super User

@Anonymous , create a slicer on Column A and table visual on Table B

 

Is that not working?

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

That would work if i had to do this just once indeed. This is the problem i face which i did not explain well enough. i want this result in the end:

RedBlueYellow
Test1Test2Test3
 Test4 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.