topic Re: REMOVING LINE LEVEL FILTER IN VISUAL MATRIX in DAX Commands and Tips

REMOVING LINE LEVEL FILTER IN VISUAL MATRIX

robertobrsp — Wed, 29 Jun 2022 13:14:41 GMT

Hi, a simple question! I need to remove the row-level filter in the matrix visual. I've tried using (ALL, ALLEXCEPT) and it didn't work. Example below:
RESULT

expected outcome

Re: REMOVING LINE LEVEL FILTER IN VISUAL MATRIX

amitchandak — Wed, 29 Jun 2022 15:05:39 GMT

robertobrsp , Simply use All()

all(Tablename)

Re: REMOVING LINE LEVEL FILTER IN VISUAL MATRIX

Anonymous — Mon, 04 Jul 2022 02:59:57 GMT

Hi robertobrsp

You can add a measure formula with an if statement to check the current value and return tag . Please refer to the link below , hope it will help you .

https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.