Reply to Message

Post Message

Subject

Event summary

Event location

Event street

Event city

Event state

Event country

** Required: Start date

**Required: End date

Event Additional

Event MetaData

Event Status

Body

never-displayed

Hint:

@ links to members

Replying to:

You can try using the below measure for Discount calculation -

Discount =

VAR DiscountAmount = calculate ([Sales Amount],

ALLEXCEPT(Discount,Discount[Sales Order Number]),Discount[Product Code]= "Discount" )

VAR SalesAmount = calculate ([Sales Amount], ALLEXCEPT(Discount,Discount[Sales Order Number]),Discount[Product Code]<> "Discount" )

Return DIVIDE(discountAmount,SalesAmount,0)

Hope this helps!

Please accept the solution if this answers your query.

Thanks!

Avantika