topic Re: Show value text column if other column filtered in DAX Commands and Tips

Show value text column if other column filtered

Anonymous — Thu, 28 Apr 2022 07:26:36 GMT

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

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.

amitchandak — Thu, 28 Apr 2022 07:43:47 GMT

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

Is that not working?

Anonymous — Thu, 28 Apr 2022 08:06:42 GMT

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:

Anonymous — Wed, 04 May 2022 09:14:02 GMT

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