topic Re: Making "Shipped Amount" and "Order Amount" Measures to make a Matrix Visual in DAX Commands and Tips

Making "Shipped Amount" and "Order Amount" Measures to make a Matrix Visual

MichaelG1117 — Sat, 16 Dec 2023 21:26:19 GMT

I can't use calculated columns in order to multiply two columns "Order Quantity" and "Sales Price" initially to get the overall Order Amount.

The Order Amount and Shipped Amount use different dates, and I need to get them both into a Matrix Visual

Initially I use SumX('table', 'table'[column1] * 'table' [column2] to get the Order Amount. But I need to specify the date somehow with regard to "Shipping Amount" in order to get the measure necessary to implement the second row into the Matrix.

I hope I am explaining this right. Any help would be awesome.

Thanks...

Re: Making "Shipped Amount" and "Order Amount" Measures to make a Matrix Visual

Fowmy — Sun, 17 Dec 2023 07:31:42 GMT

MichaelG1117

If you have created two relationships from date table to your fact table, this video should guide you to achieve the expected result:

https://youtu.be/zZLH8Y1tO1g?si=4TEFOyH4ULO8kypy

Re: Making "Shipped Amount" and "Order Amount" Measures to make a Matrix Visual

MichaelG1117 — Sun, 17 Dec 2023 15:54:30 GMT

Got it, thanks!

Re: Making "Shipped Amount" and "Order Amount" Measures to make a Matrix Visual

Fowmy — Mon, 18 Dec 2023 07:18:30 GMT

MichaelG1117

If the provided soluton worked for you please accept it as a solution so it will be useful for others as well