DAX - Product Wise Sales condition is Brand with 1

[Anonymous]

Hi Every one,

i have data like 

Product

20-20 Cookies

Coconut Cookies

Festo

Golden Arcs

Happy Happy

Hide & Seek

Hide & Seek BSC

Hide & Seek BSC

Hide & Seek BSC11

Krackjack

Kreams

Magix

Milk Shakti

Monaco-Salted Craker

Nimkin

Parle Actifit Digestive Marie

Parle Marie

some products having "1", those brands only getting sum. show results like below. sum should be my business equal to "Yes".

Product	Sales
20-20 Cookies	0
Coconut Cookies	0
Festo	0
Golden Arcs	0
Happy Happy	0
Hide & Seek	0
Hide & Seek BSC	0
Hide & Seek BSC	956290883
Hide & Seek BSC11	0
Krackjack	0
Kreams	0
Magix	0
Milk Shakti	0
Monaco-Salted Craker	808952123
Nimkin	0
Parle Actifit Digestive Marie	0
Parle Marie	879803709
Grand Total	2645046715

My actual data put in this link.

Regardss

venu

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my tests and research, I'm afraid that we cannot achive your desired output directly in power bi currently.

As you can see from your output, it seemst that you need display the Hide & Seek BSC but with different value.

Actually, the value will be be aggregated for your scenario.

If you really want to achieve the output, you could refer to my attachement. This could be a workaround.

Here is the output.

Best Regards,

Cherry