Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
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 |
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |