Search code examples
powerbidaxpowerbi-desktop

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?

Solution

  • Can you please try this below-

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