Sum by Distinctcount with exceptions

[jmcph]

Hi , I have a table like the one below: 

OR #                Product Name               Sales

01                    Combo Deal                1,000

01                    Product A                      600

01                    Product B                      400

01                    Product C                      200

02                    Product A                      500

03                    Product B                      300

04                    Product A                      200

I want to obtain a sum of sales of all product name, however, for Combo Deal the items composing it should not be part by the computation. Thus, for OR # 01 Prod A , B and C should not be added.

My expected result should be something like:

Product Name                     Sum of Sales

Combo Deal                          1,000

Product A                               700

Product B                               300

How should i put that into measure? Thank you! 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[jmcph]

Thank you for this! Totally solved my problem.

[Ashish_Mathur]

You are welcome.