Is there a DAX calculation where i can decrease a value (price) by 30%. I am trying to work out the cost price of my products which is 30% less the item price?
I have tried:
Unit cost = sumx('sales', 'sales'[ItemAmount]* 0.70)
This is giving me a very strange answer.