DAX - Product wise summarize sales

[Anonymous]

Hi every one,

I have data product wise sales for current year and & last year. 

i need to sum brand wise. when business "Yes". 

for example:

i have product like this.....

Hide & Seek Choco Chips
Hide & Seek Milano
Hide & Seek Bourbon
Hide & Seek Fab

When i going to sum it should be shown like "Hide & Seek",. output should come like below table...

Product	Sales
Nimkin	559007797
Krackjack	818483490
20-20 Cookies	564120046
Monaco-Salted Craker	535219573
Golden Arcs	739706682
Kreams	690026141
Festo	531514708
Hide & See	2510424292
Happy Happy	593745329
Parle	969647073
Magix	604267543
Coconut Cookies	564142574
Milk Shakti	573188335

Please find data in this link.

Thanks in advance....

Regards

Venu....

[Anonymous]

can any body help on this.......

[v-cherch-msft]

Hi @Anonymous 

You may create a measue like below:

Measure = CALCULATE(SUM('Product Wise Sales'[Sales]),FILTER('Product Wise Sales','Product Wise Sales'[Business]="Yes"))

Regards,

Cherie

[Anonymous]

@Anonymous

Thanks for your response....

the sample output has given in  the above.  "Hide & Seek" & "Parle" should summaraize and proivde aggregate Sasles values.

these two brands should summaraize. can you help on this...

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may add a calculated column like below.

Column = 
IF (
    SEARCH ( "Hide & Seek", 'Product Wise Sales'[Product], 1, 0 ) > 0,
    "Hide & See",
    IF (
        SEARCH ( "Parle", 'Product Wise Sales'[Product], 1, 0 ) > 0,
        "Parle",
        'Product Wise Sales'[Product]
    )
)

Regards,

Cherie

[Anonymous]

@v-cherch-msftThanks for your solution....