How to find differences between sales value based on product type column and category column

[Anonymous]

Hello,

I want to find sales value difference between the product and  category.

for eg :

(product A and category 0) has $100 sales and the (product B and category 0) has $50 then the reult in difference coulmn would be 50. Screen shot below with yellowhighlighted column.  Thanks in advance.

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=ABS([Sales]-CALCULATE(SUM([Sales],FILTER(Data,Data[Category]=EARLIER(Data[Category])&&Data[Product]<>EARLIER(Data[Product]))))

Hope this helps.

[Anonymous]

Thanks for the response Ashish...

[Ashish_Mathur]

You are welcome.