March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!
Solved! Go to 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!
@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
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
70 | |
68 |