Forum Discussion

Cbutler's avatar
Cbutler
Icon for Helper III rankHelper III
3 years ago
Solved

Help with calculate DAX!

I am having a blank moment. I am trying to do a simple calculate but I can not seem to get my filters working correctly. How can I write a measure that shows, If school 1 is selected bring back th...
CALCULATE
DAX
  • Cbutler's avatar
    Cbutler
    3 years ago

    Thanks all! You helped me get to the right result! 

    Here is what I was trying to do :0)

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago
hello this works for me:

 

 

Filtered Sum = 
    CALCULATE (
        SUM ( Table1[pupil numbers ] ),FILTER(ALL(Table1),Table1[Catchment ] = MAX(Table1[Catchment ] ) 
    )
)​