Is it possible to prevent a column filter from filtering a row in a matrix?

[AdamKaraban]

Essentially I have a matrix with two categories (locations and job title). Some locations don't have a specific job title but when I filter that job title I still want that location to appear in the matrix as completely empty.

[Anonymous]

Hi @AdamKaraban ,

You can use the REMOVEFILTERS function or ALL function to remove the effect of the filter, these are listed below:

1. REMOVEFILTERS function (DAX) - DAX | Microsoft Learn

REMOVEFILTERS:

1.Remove all filters:  CALCULATE(<expression>,REMOVEFILTERS())
2.Remove the table filter:   CALCULATE(<expression >, REMOVEFILTERS('Table'))
3.Remove the column filter:  CALCULATE(<expression >, REMOVEFILTERS('Table'[column]))

2. ALL function (DAX) - DAX | Microsoft Learn

ALL:

1.Reset all filters:  CALCULATE(<expression>,ALL())
2.Reset the table filter:  CALCULATE((<expression>,ALL('Table'))
3.Reset the column filter: CALCULATE((<expression>,ALL('Table'[column]))

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

[AdamKaraban]

I do not believe this is the solution I am looking for. This only removes the filter I have just applied. I am actually trying to do the following. I have a matrix, when I filter a column, I don't want any of the rows to dissapear even if the data in that row would become empty.

[PijushRoy]

Hi @AdamKaraban 

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Please create a pbix that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link in this thread. If you are using a spreadsheet to create/import the sample data instead of the manual import method, share the spreadsheet as well.

[PijushRoy]

Hi @AdamKaraban 

Can you please create measure with use REMOVEFILTER
https://learn.microsoft.com/en-us/dax/removefilters-function-dax
https://dax.guide/removefilters/

Please share your sample data format and matrix visual screesnhot

If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Connect Linkedin