Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Cbutler
Helper III
Helper III

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 ? 

1 ACCEPTED SOLUTION
Cbutler
Helper III
Helper III

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

Here is what I was trying to do :0)

Cbutler_0-1666269642406.png

 

View solution in original post

4 REPLIES 4
Cbutler
Helper III
Helper III

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

Here is what I was trying to do :0)

Cbutler_0-1666269642406.png

 

eliasayy
Impactful Individual
Impactful Individual

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

eliasayy
Impactful Individual
Impactful Individual

hello this works for me:

 

 

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

 

 

Screenshot 2022-10-20 152252.png

 

Screenshot 2022-10-20 152300.png

Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

 

Jihwan_Kim_0-1666268066348.png

 

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

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.