Slicer does not trigger card value

[Pbiuserr]

Hello, 

Looking for the picture down below P HC supposed to be 0, as I slice on "PermTmpCOD" = T. The measure is standard P HC = CALCULATE ( [HC], PermTmpCOD = "P"). I tried with ALLSELECTED but it didnt work. For the datamodel its standard one to many connection, two tables

[PabloDeheza · Accepted solution]

Hi there!

Try the following:

 CALCULATE ( [HC], KEEPFILTERS( PermTmpCOD = "P" ) )

Let me know if that helps!

[Pbiuserr]

It works! Can you elaborate a little what you've done?

[PabloDeheza]

Sure thing!

So, when you apply a "filter" with CALCULATE, you are essencially removing any existing filter applied to the same column, replacing it with the new filter that you defined. If you dont want to lose the existing filter, then KEEPFILTERS comes in handy as it will keep the filter that you applied outside of the measure, and also the filter applied on your CALCULATE function.

For a better understanding of this I suggest reading this posts:

CALCULATE 

KEEPFILTERS