Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
School 1 slelected = 30 catchment School 2 selected = 30 catchment
School 3 selected = 70 catchment
School 4 selected = 70 catchment
An easy one for someone who doesnt have brain fog I am sure! @Greg_Deckler ?
Go to Solution.
Thanks all! You helped me get to the right result! Here is what I was trying to do :0)
View solution in original post
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
Filtered Sum =
SUM ( Table1[pupil numbers ] ),FILTER(ALL(Table1),Table1[Catchment ] = MAX(Table1[Catchment ] )
Please check the below picture and the attached pbix file.
expected result: =
HASONEVALUE ( Data[School] ),
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.