Total in every row

[Pikachu-Power]

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 Categories A, B, C as variable.

I use a table with the columns ABC_Categories and so on...

🤔

[v-jayw-msft]

Hi @Pikachu-Power ,

Do you want totals for row or for columns? Can you share some sample data and expected result to us?

Best Regards,

Jay

[amitchandak]

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

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]

@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]))