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)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

expected result: =
IF (
    HASONEVALUE ( Data[School] ),
    CALCULATE (
        SUM ( Data[Pupil Numbers] ),
        FILTER ( ALL ( Data ), Data[Catchment] = MAX ( Data[Catchment] ) )
    )
)