Measure (no slicer interaction) referencing another measure (with slicer interaction)

[force111]

I'm not even sure how to properly describe this, but let's say I have a slicer with names in it. Separately, in a data table I have the corresponding region for each individual.

Now, I have one card with a number on it that is supposed to represent total number of people in a region based on the name selected on a slicer on screen. I have turned off Edit Intereactions because otherwise the measure just returns a value of 1 (since 1 individual is selected).

I have a second measure to get the region based on the name selected, since it's not impacted by the slicer.

For demonstration purposes, let's say I have John Smith from Ontario selected. The second measure correctly gets the value of Ontario. However, the first measure even when directly referencing the second measure, just returns a value of Alberta, regardless of any name chosen. I don't understand why. I've pasted a couple pictures with very basic formulas if helpful. Thanks!

[Anonymous]

Hi @force111 

You can try the following measure.

Region UW Denominator =
CALCULATE (
    DISTINCTCOUNT ( 'UW Loans'[UnderWriter Name] ),
    FILTER ( ALL ( 'UW Loans' ), 'UW Loans'[UnderWriter Region] = [SelectedRegion] )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.