Using a measure in a filter calculation

[shaunparsons66]

I have a measure that I'm using to sum a range of numbers, filtered by a specific value in a corresponding column:

Benchmark Measure - Region =

CALCULATE

(SUM('WIFI-Analysis'[Last Month Avg Daily Turnup]),

FILTER('WIFI-Analysis','WIFI-Analysis'[Region] = "EMEA"))

However, I don't want to include the manual "EMEA" variable. Instead, I want to use a measure. I have created this measure, but when I include the measure in place of "EMEA" it doesn't seem to work, despite the measure itself working fine and showing the correct value "EMEA" when I place it elsewhere on the canvas.

Any ideas what I'm doing wrong?

Thanks

[shaunparsons66]

I'm afraid DropBox is blocked on my company computer. How do people normally share files on here?

[AnkitKukreja]

You can try one drive or attach the file here if you see the option.

[AnkitKukreja]

Hi! @shaunparsons66 

It would be great if you can share some sample data and expected solution, this will help me understand your problem in a better way.

[shaunparsons66]

Afraid I can't use any of those. Based on the DAX formula I've used above, are you not able to see what I'm doing wrong? I'm fairly certain I'm just not using the right formula to target the measure properly...