Static Columns when using a filter

[Anonymous]

I have a matrix table and I want to ensure that one particular column in that table remains static (does not alter when adjusting a filter on the dashboard). How do I do this?

[v-xicai]

Hi @Anonymous  ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Anonymous ,

You could use ALL() Function in your formula.

for example:

Measure 1 = CALCULATE(SUM('Table'[sale]),ALL('Table'))

For reference:

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

Best Regards,

Amy

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