cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pbiuserr
Post Prodigy
Post Prodigy

Slicer does not trigger card value

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

 

Pbiuserr_1-1660651383413.png

 

 

1 ACCEPTED SOLUTION
PabloDeheza
Super User
Super User

Hi there!

Try the following:

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

Let me know if that helps!

View solution in original post

3 REPLIES 3
PabloDeheza
Super User
Super User

Hi there!

Try the following:

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

Let me know if that helps!

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

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 

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors