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

[Aamir2021]

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

[v-jayw-msft]

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

[amitchandak · Accepted solution]

@Aamir2021 , Try a measure like

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

[Aamir2021]

Thanks for your suggestion.

[Aamir2021]

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.

[amitchandak]

@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)))