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 ,

Thank you for reaching out to the Microsoft Community Forum.

 

Hi KNP  and Ahmed-Elfeel , Thank you for your prompt responses.

 

Hi Bandana_Havana9 ,  Could you please try the proposed solutions shared by KNP  and Ahmed-Elfeel  ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

 

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

  • 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