topic How to get DAX measure for Unit Price*Quantity-Discount 20% in DAX Commands and Tips

How to get DAX measure for Unit Price*Quantity-Discount 20%

Aamir2021 — Thu, 03 Feb 2022 05:32:46 GMT

Hi,

I want to calculate with the help of DAX below measure

Unit Price * Quantity - Discount 20%

How to get the DAX measure?

I would be grateful if you could help me with this problem.

Thank you

Re: How to get DAX measure for Unit Price*Quantity-Discount 20%

amitchandak — Thu, 03 Feb 2022 05:44:18 GMT

Aamir2021 , Try a measure like

Sumx(Table, ([Unit Price] * [Quantity])*0.8)

Re: How to get DAX measure for Unit Price*Quantity-Discount 20%

Aamir2021 — Thu, 03 Feb 2022 06:45:25 GMT

Hi amitchandak,

Thanks for your reply. However, it does not work.

There are three tables. The first table has Unit Price, second table has Order Quantity and last table has Discount allowed in percantage.

My question is the Unit price is 15, Order Quantity is 20 and Discount allowed is 20%

So how can we calculate dax to get the Sales after discount?

I hope you get the my point.

Re: How to get DAX measure for Unit Price*Quantity-Discount 20%

amitchandak — Thu, 03 Feb 2022 07:38:38 GMT

Aamir2021 , You need a common dimension. assume you have these measures from two tables

[Unit Price] , [Quantity] and common item dimension

Sumx(values(item[Item ID]), calculate(([Unit Price] * [Quantity])*0.8)))

Re: How to get DAX measure for Unit Price*Quantity-Discount 20%

Anonymous — Wed, 23 Feb 2022 09:39:14 GMT

Hi Aamir2021 ,

You will need relationships between these tables. That would help Power BI to get the corresponding Quantity for specific Unit Price along with the Discount. Perhaps you have a product column in the table?

Best Regards,

Jay

Re: How to get DAX measure for Unit Price*Quantity-Discount 20%

Aamir2021 — Sun, 06 Mar 2022 05:47:49 GMT

Thanks for your suggestion.