How to ignore filter from a column in matrix

[maciekkkm]

Hi,

I have the following question.

Is there a possibility to manipulate filters, in this case from a date column?
I would like to have "total sold" only displaed once at the end of a matrix, not per each months, while "total baked" should be splited as it is. I have tried will a combination of "remove filters" etc, however, it didn't work.

Thanks in advance.

[v-nuoc-msft]

Hi @maciekkkm 

This has to do with the design of power bi, where you can't display "total sold" only once at the end of the matrix.

You might consider creating a calculated measure that adds up the "Total Sales" for all months. This measure is then placed outside the matrix or only displayed in the last individual visual object.

Regards,

Nono Chen

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