Measure is not being affected by a filter with the same field.

[James314]

Hi

I have the following measure: 

Admissions = CALCULATE(SUM('Fact'[Attends]),'Fact'[Admitted?]="Admitted")

It's working fine and most filters are affecting it as they should, however the on page filter visual for 'Fact'[Admitted?] (same field as in the measure) is not working.

When I select "Not Admitted" in the on page filter visual I expect the measure to show 0 but it isn't changing. Resulting in having more admission than attends.

I can't share data as it is sensitive and I don't have time to make a dummy dataset right now. I'm hoping someone can tell me theres a way to have a filter in a CALCULATE statement and in an on page filter visual working together.

Thanks in advance.

[rajendraongole1 · Accepted solution]

Hi @James314 - Use the below measure with explicitly by using filter function within calculate

Admissions =
CALCULATE(
SUM('Fact'[Attends]),
FILTER(
'Fact',
'Fact'[Admitted?] = "Admitted"
)
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[James314]

This is great thank you! Can I ask why this works?