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 !
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.
SebSchoon1Post Patron
Post PatronHello 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 !