cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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 1 10 A 2 20 A 3 30 B 4 40 B

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

1 ACCEPTED SOLUTION
Helper III

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

Here is what I was trying to do :0)

4 REPLIES 4
Helper III

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

Here is what I was trying to do :0)

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

Impactful Individual
hello this works for me:

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

Super User

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

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.

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors