Remove columns from matrix without changing row percentage

[Intellar]

I got a matric table with multiple columns based on 1 field
Now for display i want to remove 2 column values but that changes the percentage values of the other columns while they should remain the same.
Is there a way to not show the columns withoud changing the percentages?

Standard

After removing the second column

[Anonymous · Accepted solution]

Hi @Intellar 

You can consider to use ALL() or ALLEXCEPT() function. it will not affected by the filter.

e.g 

Measure =
CALCULATE ( SUM ( table[value] ), ALLEXCEPT ( table, [Month] ) )

You can refer to the following link about the functions.

ALL function (DAX) - DAX | Microsoft Learn

ALLEXCEPT function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.