Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
SebSchoon1
Post Patron
Post Patron

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.

 

SebSchoon1_0-1664801093920.png

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

 

SebSchoon1_1-1664801480035.png

 

Many thanks in advance!

1 ACCEPTED SOLUTION

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!

 

 

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@SebSchoon1 This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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!

 

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.