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"})
    )

     

     

     

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
10 months ago

Hi Bandana_Havana9 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
10 months ago

Hi @Bandana_Havana9 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh