Forum Discussion
ArchStanton
Power Participant
Power ParticipantKEEPFILTERS?
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"}) ...
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" } ) )
ajohnso2
Solution Supplier
Solution SupplierWhat is the dax inside your measure namec All Cases?
ArchStantonPower Participant
Power ParticipantAll Cases =
DISTINCTCOUNT('Cases'[Case Number]
)