Table with multiple values error

[mymoosa]

Hi All

This is the measure i have created ... it gives me an error saying multiple values ... when i add a filter for TaskGrade.  The reason for this filter is : Students in Grade 11 2021 Term 1 marks need to be analysed against Grade 10 2020 Term 4 marks.  

PT1 = switch(

max('View_SBA_GLS_Per_Student_Total'[Term])

,"Term 1",0+ CALCULATE(

AVERAGE(View_SBA_GLS_Per_Student_Total[TotalWM])

,'View_SBA_GLS_Per_Student_Total'[Term]="Term 4",value('View_SBA_GLS_Per_Student_Total'[Year]) = DISTINCT('View_SBA_GLS_Per_Student_Total'[PrevYr]), value('View_SBA_GLS_Per_Student_Total'[TaskGrade]) = DISTINCT('View_SBA_GLS_Per_Student_Total'[PrevYrGr]))

,"Term 2", 0 + CALCULATE(AVERAGE(View_SBA_GLS_Per_Student_Total[TotalWM]),'View_SBA_GLS_Per_Student_Total'[Term]="Term 1")

,"Term 3",0 + CALCULATE(AVERAGE(View_SBA_GLS_Per_Student_Total[TotalWM]),'View_SBA_GLS_Per_Student_Total'[Term]="Term 2")

,"Term 4",0 + CALCULATE(AVERAGE(View_SBA_GLS_Per_Student_Total[TotalWM]),'View_SBA_GLS_Per_Student_Total'[Term]="Term 3"))

I do not know why it is bringing thru multiple values... as the PrevYr column works perfectly.  Should PrevYrGr not work just the same

[Anonymous]

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...

[mymoosa]

Here is a copy of the pbix file.

I hope this can help.... really lost no