Forum Discussion

shaunparsons66's avatar
shaunparsons66
Helper I
4 years ago

Using a measure in a filter calculation

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
Need Help
Show and Tell

4 Replies

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    4 years ago

    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's avatar
      shaunparsons66
      Helper I
      4 years ago

      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...

  • shaunparsons66's avatar
    shaunparsons66
    Helper I
    4 years ago

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

    • AnkitKukreja's avatar
      AnkitKukreja
      Super User
      4 years ago

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