Forum Discussion

ChumaAmako's avatar
ChumaAmako
Helper I
8 years ago
Solved

Sum with ALL Function filters

Hi guys,   I have a stock count table for different products in different outlets.   Like this:   Outlet ID SKU ID Total Stock Count 1001 Apples 12 1001 Bananas 20 1001 Carrots 0 1002 Apple...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Here is the calculated field formula i wrote

     

    =CALCULATE(SUM([Total stock count]),ALL(Data[SKU ID]),FILTER(SUMMARIZE(VALUES(Data[Outlet ID]),[Outlet ID],"ABCD",SUM(Data[Total stock count])),[ABCD]>0))

ChumaAmako's avatar
ChumaAmako
Helper I
8 years ago

Hi Ashish_Mathur this works even better and is more system resource efficient, because you used a measure and not a calculated column.

 

Thanks so much for your help as always.

 

God Bless you.

 

Regards,

Chuma.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

You are welcome.