Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
2 years ago
Solved

KEEPFILTERS?

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"}) ...
Need Help
Show and Tell
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    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" } )
)

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

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's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    2 years ago

    Thanks, that works!👍