Forum Discussion

Bandana_Havana9's avatar
Bandana_Havana9
New Member
10 months ago
Solved

Filter and Sum

Hi,    I need add together the items sold based on specified sales code.  This is what I currently have, but it is not working. Do I need to create a measure for grouping the sales code first (1000...
  • KNP's avatar
    KNP
    10 months ago

    It's difficult to be sure without seeing your model and relationships, but, I would think this syntax should work.

     

    Total Black = 
    CALCULATE(
        SUM(FactInternetSales[SalesAmount])
        , FILTER(DimProduct, DimProduct[Color] IN {"Black"})
    )

     

     

     

KNP's avatar
KNP
Icon for Super User rankSuper User
10 months ago

It's difficult to be sure without seeing your model and relationships, but, I would think this syntax should work.

 

Total Black = 
    CALCULATE(
        SUM(FactInternetSales[SalesAmount])
        , FILTER(DimProduct, DimProduct[Color] IN {"Black"})
    )