Forum Discussion
Pikachu-Power
Impactful Individual
Impactful IndividualTotal 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...
Pikachu-PowerImpactful Individual
Impactful IndividualOk 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
Super User
Super UserPikachu-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]))