Forum Discussion
Solved
DAX comparison error (comparing text with True/False) after adding filter?
Hi, I have the following formula - Phonics Yr 1 Expected = CALCULATE([Expected],'A15 Pupil_Assessments'[Assessment] IN { "Phonics Att" })+0 which works fine but I would like to filter it on ...
Im not sure I understand correct your logic from a second sentence but if you need AND logic by 2 conditions you can use
Phonics Yr 1 Expected = CALCULATE([Expected], 'A15 Pupil_Assessments'[Assessment] IN { "Phonics Att" }, 'A15 Pupil_Assessments'[Resultset]="STEP Yr 1 Autumn Target" )+0
Im not sure I understand correct your logic from a second sentence but if you need AND logic by 2 conditions you can use
Phonics Yr 1 Expected =
CALCULATE([Expected],
'A15 Pupil_Assessments'[Assessment] IN { "Phonics Att" },
'A15 Pupil_Assessments'[Resultset]="STEP Yr 1 Autumn Target"
)+0
Thank you so much, I'd tried that but had the comma for the filter in the wrong place and it kept coming up with an error in the formula.
I'm sure DAX is logical to most but I just struggle to get my head round it!