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 the total for Catchment A


so,

School 1 slelected = 30 catchment 
School 2 selected = 30 catchment 

School 3 selected = 70 catchment 

School 4 selected = 70 catchment 

 

School pupil numbers Catchment 
110A
220A
330B
440B

 

An easy one for someone who doesnt have brain fog I am sure! Greg_Deckler ? 

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)

     

4 Replies

  • 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] ) )
    )
)

     

  • 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 ] ) 
    )
)​

     

     

     

     

     

  • Cbutler's avatar
    Cbutler
    Icon for Helper III rankHelper III
    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

      no probelm but for better practice use BLANK() instead of " " in the end because " " is text form to if you want to use it for other calculations