cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## How to get a group total from a single filtered value?

How can I get the filtered value of a group from a single value?
I am looking at pupil numbers by school (individual school code) and the schools locality (multiple schools per locality/catchment)

Heres a cut of my data (.Total Pupils is a measure)

I am displaying the number of pupils by school in a bar chart, then the sum of pupils by locality/catchment on a shape map, listing the total by school and locality/catchment

When I select a locality/catchment on the map this filters the report correctly, filtering all the schools and the total number of pupils in that locality/catchement

When I filter the bar chart I would like to disaplay the total number of pupils in the selected school, but the total for the locality/catchment, buut I cant workout the DAX to do this....at the mo it just displays the total for the selected school 😞

My display label is working but I cant calculate the total for the selected locality, can anyone help?

I tried all sorts to get this working but I am abviously missing something.

1 ACCEPTED SOLUTION
Super User

@Cbutler

The following measure will show you the total for the locality of the school coded selected:

Locality Total =
var __local = SELECTEDVALUE(Table[Locality]) return
CALCULATE(
[Total Pupil],
Table[Locality] = __local,
ALL(Table[School Code])
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up
2 REPLIES 2
Super User

@Cbutler

The following measure will show you the total for the locality of the school coded selected:

Locality Total =
var __local = SELECTEDVALUE(Table[Locality]) return
CALCULATE(
[Total Pupil],
Table[Locality] = __local,
ALL(Table[School Code])
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper III

Brilliant thanks! thats got it! Thanks you so much!

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors