Forum Discussion
Remove columns from matrix without changing row percentage
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
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.
1 Reply
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.