Forum Discussion
Post PatronGet Total Values at row level And Total value at columns Level After MOD() fucntion
Hi Guys,
Thanks to the community i can learn so many things! Thank you!
I would like to get the total of decimal part in my Table
But also Keep in rows a specific value.
Here is my table
my model
a link to my file
Hello Anonymous
I Managed it by doing
reliquat total = VAR REL= [(1)Nombre décimal Répartition]
VAR TOTREL = CALCULATE([(1)Nombre décimal Répartition],REMOVEFILTERS('Tableau Dispatch'[CODE DEPOT]))
return if([Répartition]<>BLANK(),TOTREL,BLANK())Which is maybe not the optimal way to do ^^
But it worked !
4 Replies
- Greg_Deckler
Community Champion
SebSchoon1 Not sure I am following, is the total in your table incorrect? If that is the case, 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
SebSchoon1Greg_Deckler Hi Sir,
I'd like to have in the rows a value of 2 (which is decimal part of répartition * [Total Dépots])
And have a total of 4 since the two items have a total residue quantity of 2
so 2 + 2 = 4
🙂
Hi SebSchoon1 ,
Here I suggest you to try this code.
correct total = SUMX ( SUMMARIZE ( ADDCOLUMNS ( 'Tableau Dispatch', "code", RELATED ( 'Base Article'[CODE ARTICLE] ) ), [CODE ARTICLE], [CODE DEPOT] ), [partie décimale répartition] )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
