Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago

Total in every row

hi,   i have a simple formula where i want the total in every row but it dont work:   XYZ = CALCULATE(SUM(Table[Number]), ALL(Table[ABC_Categorie]))   ABC_Categorie is a created COLUMN with Ca...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Pikachu-Power , Try like

 

Grand total

XYZ = CALCULATE(SUM(Table[Number]), ALL(Table))
XYZ = CALCULATE(SUM(Table[Number]), ALLSELECTED(Table))

 

or sub total
XYZ = CALCULATE(SUM(Table[Number]), ALLexpect(Table,Table[ABC_Categorie]))

  • Pikachu-Power's avatar
    Pikachu-Power
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Ok I didnt use ALL(Table) because I have a time filter at the filter pane where I want to use further. But I include it in the formula.  

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      Pikachu-Power , The best way to ignore only the category is to have that in a separate table joining to the fact. So you can use all on that table and another filter can work.

       

      you can try this and check,

      XYZ = CALCULATE(SUM(Table[Number]), removefilters(Table[ABC_Categorie]))

       

      new Table wat

      XYZ = CALCULATE(SUM(Table[Number]), all(Categorie[ABC_Categorie]))