Forum Discussion

SebSchoon1's avatar
SebSchoon1
Icon for Post Patron rankPost Patron
3 years ago
Solved

Can't Change total to specific Level Row

Hi guys,

 

I have this Formula

 

répartition hors taille = 

 VAR SummaryTable = ADDCOLUMNS(

                        SUMMARIZE('Tableau Dispatch','Base Article'[CODE ARTICLE],'Tableau Dispatch'[Rank dispatch],'Tableau Dispatch'[CODE DEPOT]

                    ),

                   "Tous dépots",

                   

                   VAR TOTNOSIZE = CALCULATE(sumx('Tableau Dispatch',[Distribution finale]),ALLSELECTED('Base Article'[CODE ARTICLE]))

                   RETURN TOTNOSIZE)

            RETURN

              SUMX(SummaryTable,[Tous dépots])

Which provide me this result.

 

The quantities are Right,

 

However, i'd like The sum if theses By [CODE DEPOT] not taking in account the [TAILLE] Filtered context.

 

So instead of 1 in last columns for warehouse 015  i'dl like to have 2 then 1 for the warehouse with only 1 quantity.

 

Here is my model

 

 

Many thanks in advance!

  • SebSchoon1's avatar
    SebSchoon1
    3 years ago

    Hello,

     

    I have found the Solution (sorry for the Spam) 

     

     

    Total quantités tous dépots 3 = CALCULATE([Stock],ALLSELECTED('Base Article'))

     

    Have a nice day!

     

     

2 Replies