cancel
Showing results for
Did you mean:
Regular Visitor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

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

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
3 REPLIES 3
Highlighted
Super User IV

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

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Regular Visitor

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

Thanks for the response Ashish...

Super User IV

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

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!