KEEPFILTERS?

[ArchStanton]

Hi,
The following measure shows the same total for each person

SI Team = 
CALCULATE(
    [All Cases],
    Owners[Name] IN {"Ian Bloggs", "Siobhan Bloggs", "George Best", "Billy Chaplin"})

When I add KEEPFILTERS to fix the measure I get the following error - any ideas how to fix this?

SI Team = 
CALCULATE(
    KEEPFILTERS(
    [All Cases]),
    Owners[Name] IN {"Ian Bloggs", "Siobhan Bloggs", "George Best", "Billy Chaplin"})

I'm guessing this has something to do with the Team structure hierarchy?
Thanks

[AlexisOlson · Accepted solution]

The KEEPFILTERS function goes around the filter argument, not the measure.

Try this instead:

SI Team =
CALCULATE (
    [All Cases],
    KEEPFILTERS ( Owners[Name] IN { "Ian Bloggs", "Siobhan Bloggs", "George Best", "Billy Chaplin" } )
)

[ArchStanton]

Thanks, that works!👍

[ajohnso2]

What is the dax inside your measure namec All Cases?

[ArchStanton]

All Cases = 
           DISTINCTCOUNT('Cases'[Case Number]
            )