Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 and A-Levels" but I am not sure how to write this. Can anyone help? Thank you very much
Solved! Go to Solution.
Hola @claret_mug ,
Compruebe la fórmula a continuación. "&&" como "y", "a" como "o".
BTEC + Progression all years =
CALCULATE (
[Total students],
FILTER (
'Table1',
'Table1'[Collaborative Provision Indicator] = "Non-collaborative"
&& 'Table1'[Course length 1 year or less] = "No"
&& 'Table1'[Program level] = "No UG "
&& 'Table1'[Course Mode (FT / PT)] = " Full Time "
&& 'Table1'[Entry Route] = " UCAS / GTTR "
&& 'Table1'[EU Overseas Home Residence] = " Home "
&& ( 'Table1'[Entry Qualification Mapping] = "BTEC Only"
|| 'Table1'[Entry Qualification Mapping] = "Mixed BTEC and A-Levels" )
)
)
Saludos
Jay
Hola @claret_mug ,
Compruebe la fórmula a continuación. "&&" como "y", "a" como "o".
BTEC + Progression all years =
CALCULATE (
[Total students],
FILTER (
'Table1',
'Table1'[Collaborative Provision Indicator] = "Non-collaborative"
&& 'Table1'[Course length 1 year or less] = "No"
&& 'Table1'[Program level] = "No UG "
&& 'Table1'[Course Mode (FT / PT)] = " Full Time "
&& 'Table1'[Entry Route] = " UCAS / GTTR "
&& 'Table1'[EU Overseas Home Residence] = " Home "
&& ( 'Table1'[Entry Qualification Mapping] = "BTEC Only"
|| 'Table1'[Entry Qualification Mapping] = "Mixed BTEC and A-Levels" )
)
)
Saludos
Jay
Hola @claret_mug
se puede utilizar
Con saludos amables desde la ciudad donde la leyenda del 'Pied Piper de Hamelin' está en casa
FrankAT (Orgulloso de ser un Datanaut)
@claret_mug , O puede ser como
Tabla1[Asignación de calificación de entrada]-"Sólo BTEC" ? Tabla1[Asignación de calificación de entrada]"Lamezcla de BTEC y los niveles A"
o el uso en
Tabla1[Asignación de calificación de entrada] en "BTEC",mezcla de niveles BTEC y A"