Forum Discussion
SebSchoon1
Post Patron
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 ta...
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 !
SebSchoon1Post Patron
Post PatronGreg_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 Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- SebSchoon1
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 !