How to turn off slicer interaction for only 1 column in matrix

[KIT_LKN]

Got measure that counts number of new cases like this:

NumberOfNewCases = CALCULATE (
                   SUM('Production'[Value]), 
                   FILTER ('Production', ('Production'[Status]) = "New"))

I've added this to my matrix as "Values" (visually it's a column!). Matrix holds 10 different columns, but for only his one I want to turn off slicer interaction - for all 5 slicers on page/visual - and display number of "new" unchanged. Is this possible? I can't use "Edit interactions" on this, as it will limit all 10 columns in matrix. 

[Idrissshatila · Accepted solution]

Hello @KIT_LKN ,

Try the removefilter function in dax https://learn.microsoft.com/en-us/dax/removefilters-function-dax

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[FreemanZ]

hi @KIT_LKN 

try like:
NumberOfNewCases =
CALCULATE (
SUM('Production'[Value]),
FILTER ('Production', ('Production'[Status]) = "New")),
ALL(Production[SlicerColumn])
)

[Anonymous]

This has been asked before see:
powerbi - How to exclude a column from slicer? - Stack Overflow
This solution should work for you aswell.

[Idrissshatila · Accepted solution]

Hello @KIT_LKN ,

Try the removefilter function in dax https://learn.microsoft.com/en-us/dax/removefilters-function-dax

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[KIT_LKN · Accepted solution]

REMOVEFILTERS seems to be what I was looking for, but I could not make it work with both FILTER and REMOVEFILTERS (several) in same measure, so I made a workaround. Kept my first measure unchanged, and then added another measure "NumberOfNewCasesExFilters" to draw data from the first one. And the second measure did the trick.

NumberOfNewCases = CALCULATE (
                   SUM('Production'[Value]), 
                   FILTER ('Production', ('Production'[Status]) = "New"))




NumberOfNewCasesExFilters = CALCULATE([NumberOfNewCases], 
    				REMOVEFILTERS('ORG'[Level1], 
                    					ORG[Level1], 
                    					ORG[Level2], 
                    					ORG[Level3], 
                    					ORG[Level4] ) )