Show value text column if other column filtered

[Anonymous]

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

Column A	Column B
Red	Test1
Blue	Test2
Yellow	Test3
Blue	Test4

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.

[Anonymous]

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]

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

Is that not working?

[Anonymous]

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:

Red	Blue	Yellow
Test1	Test2	Test3
	Test4