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

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi ChumaAmako,

 

I created a column with the formula below ( my table is called FinalSan then I created a Table:

TestColumn2 =
IF (
    FinalSan[TotalStock Count] = 0,
    0,
    CALCULATE (
        SUMX ( FinalSan, FinalSan[TotalStock Count] ),
        ALLEXCEPT ( FinalSan, FinalSan[Outlet ID] )
    )
)

 

 

 

Please let us knw if you have any observations.

 

Ninter

ChumaAmako's avatar
ChumaAmako
Helper I
8 years ago

Hi Interkoubess this works fine for me.

 

Thank you.

 

Regards,

Chuma.