Calculate with all option

[Harsh]

Hello @mjmcs13,

Thank You for posting your query onto the Forum.

Well, in this case, I’m presuming that when you say “ALL” option is not working you mean that eventhough when you make a selection in the slicer for Schools, the percentages should not change upon those selections.

Below is the measure alongwith the screenshot of the final results provided for the reference -

SB Math Average - Harsh = 
CALCULATE(
    CALCULATE(
        AVERAGEX( Assessments , 
            Assessments[Performance_Score] ) ,
        FILTER( Assessments , 
            Assessments[TEST_SHORTNAME] = "SB"  && 
            Assessments[SUBLEVEL1_SHORTNAME] = "MATH"  ) ) , 
    ALL( School_LKP ) )

I’m also attaching the working of the PBIX file as well as providing few of the links below of the posts which our expert @AntrikshSharma has created.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

Filter By all schools - Harsh.pbix (130.9 KB)

CALCULATE Mantra

Here are some steps that I recite when I am stuck with a complex problem, it is always good remember CALCULATE’s execution order. Evaluates all the filter arguments of CALCULATE in the original filter context that is active outside CALCULATE and then are kept aside CALCULATE creates a new Filter by copying the original filter context If it is called in a Row Context, either by an iterator or Calculated column then it takes that particular row and create an equivalent filter from values …

How filters are evaluated in CALCULATE

Someone asked this question on Power BI Community forum and I think it will be a good learning for those who are new to DAX as when I was starting to learn it was unclear for a very long time that how 2 similar expression are calculating differently.