CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
user19351102
user19351102

Reputation: 51

New Table based on another Table values

I want to create a new table in Power BI using values of another table. My Original table ARM DATA, has three columns Destination, Sales and Product. I want to create a new table with all the possible DEST and the Sales when the product equal "PHA".

This is my current DAX formula but I don't know how to add only sales for Pharma.

New Table = 
SUMMARIZE(
    'ARM DATA', 
    'ARM DATA'[Destination],
    "Sales", SUM('ARM DATA'[Sales])
)

Can this be done?

Upvotes: 1

Views: 294

Answers (1)

mkRabbani
mkRabbani

Reputation: 16918

Can you please try this below-

New Table = 
SUMMARIZE(
    FILTER('ARM DATA', 'ARM DATA'[Product] = "PHA"), 
    'ARM DATA'[Destination],
    "Sales", SUM('ARM DATA'[Sales])
)

Upvotes: 0

Related Questions