Forum Discussion

SebSchoon1's avatar
SebSchoon1
Icon for Post Patron rankPost Patron
3 years ago
Solved

Get 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...
Need Help
  • SebSchoon1's avatar
    SebSchoon1
    3 years ago

    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 !

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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's avatar
    SebSchoon1
    Icon for Post Patron rankPost Patron
    3 years ago

    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

     

    🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        SebSchoon1
        Icon for Post Patron rankPost Patron
        3 years ago

        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 !