topic Re: DAX (Matrix) in DAX Commands and Tips

DAX (Matrix)

Anonymous — Thu, 27 Jan 2022 10:01:45 GMT

Hi all,

I would like to pull a data from Matrix visual to data field.

Is that possible?

For eg: This is my Matrix table.

and

This is my table in data field.

Part Number is a field which is common in both.

I would like to Lookup "BAU: DDMRP in scope process" from matrix visual to "New Buffer profile" .

Is that possible?

If so, can I please know how to do it?

Any help is appreciated!

Thank you!

Megha

Re: DAX (Matrix)

amitchandak — Thu, 27 Jan 2022 12:06:19 GMT

Anonymous , You can not bring column from visual to table , You can bring from table to table

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Re: DAX (Matrix)

ValtteriN — Thu, 27 Jan 2022 12:09:45 GMT

Hi,

Unfortunately, you can't refecence visuals with DAX so what you are describing is not possible. However, you can create a calculated column with the same filter condition as with your table, but I for that you should specify your goals a bit more e.g. "I am trying to calculate BAU: DDMRP in context X".

Re: DAX (Matrix)

Anonymous — Thu, 27 Jan 2022 17:30:37 GMT

amitchandak

Is it possible to bring a column from matrix visual to a table visual?

Thank you!

Megha

Re: DAX (Matrix)

v-robertq-msft — Tue, 01 Feb 2022 07:39:59 GMT

Hi,

As far as I’m concerned, the only solution is to use the “Export data” in the desktop to export the value in the matrix into the format of CSV:

Then you can go to the Power Query to add the CSV as the data source to be combined into the original dataset:

Then you can ues the “Merge query” function in the Power Query to add the column “BAU: DDMRP In Scope Process” to the dataset and change the column name to "New Buffer profile"

And you can get what you want.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.