Forum Discussion

Jasonvl's avatar
Jasonvl
Frequent Visitor
6 years ago
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 ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Jasonvl 

    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
amitchandak's avatar
amitchandak
Super User
6 years ago

Jasonvl , like this

Phonics Yr 1 Expected = CALCULATE([Expected],filter('A15 Pupil_Assessments', 'A15 Pupil_Assessments'[Assessment] IN { "Phonics Att" }
&& 'A15 Pupil_Assessments'[Resultset]="STEP Yr 1 Autumn Target" ))+0