cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
claret_mug
Frequent Visitor

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 and A-Levels" but I am not sure how to write this. Can anyone help? Thank you very much

 

BTEC + Progression all years = CALCULATE ([Total students], '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" )
1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
FrankAT
Community Champion
Community Champion

Hola @claret_mug

se puede utilizar

  1. el signo de doble tubería '', se puede utilizar tan a menudo como sea necesario
  2. la función OR(). La función OR() solo acepta 2 argumentos.

Con saludos amables desde la ciudad donde la leyenda del 'Pied Piper de Hamelin' está en casa
FrankAT (Orgulloso de ser un Datanaut)

amitchandak
Super User
Super User

@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"

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Kudoed Authors