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!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |