Table with multiple values error

mymoosa — Wed, 08 Sep 2021 13:01:18 GMT

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

Re: Table with multiple values error

mymoosa — Thu, 16 Sep 2021 10:31:17 GMT

Here is a copy of the pbix file.

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

topic Re: Table with multiple values error in DAX Commands and Tips

Table with multiple values error

Re: Table with multiple values error

Re: Table with multiple values error