Forum Discussion
Solved
using OR in measures
Hello I have the following measure that calculates the number of students who have made progress. For the 'Entry Grade Mapping' I want to include students if they are "BTEC only" or " Mixed BTEC ...
claret_mug , Not very clear with formula
Or can be like
Table1[Entry Qualification Mapping]="BTEC only" || Table1[Entry Qualification Mapping]="Mixture of BTEC and A-Levels"
OR( Table1[Entry Qualification Mapping]="BTEC only" , Table1[Entry Qualification Mapping]="Mixture of BTEC and A-Levels")
or use in
Table1[Entry Qualification Mapping] in {"BTEC" ,"Mixture of BTEC and A-Levels"}