Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Difference of Rows

working on a project where I want to create measure/DAX of price difference between brands.Using the following data I want to create the price diffrence between Brand A with All other brands for regi...
Need Help
Show and Tell
Tips and Tricks
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

try this 

difference = 
    var _PriceA = CALCULATE(MIN('Table'[Price]),FILTER(ALLSELECTED('Table'),'Table'[Brand Name]="A"))
    var _currPrice = MIN('Table'[Price])
return _currPrice-_PriceA

result

if you need more help, please @ me.

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.