Get Total Values at row level And Total value at columns Level After MOD() fucntion

[SebSchoon1]

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

https://we.tl/t-KwOgHOZDJF

[Greg_Deckler]

@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

[SebSchoon1]

@Greg_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

🙂

[v-rzhou-msft]

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 · Accepted solution]

Hello @v-rzhou-msft 

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 !