Forum Discussion

claret_mug's avatar
claret_mug
Frequent Visitor
5 years ago
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 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" )
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi claret_mug ,

     

    Check the formula below. "&&" as "and", "||" as "or".

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

     

    Best Regards,

    Jay

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

     

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi claret_mug 

    you can use

    1. the double pipe sign '||', can be used as often as you need
    2. the function OR(). The OR() function accepts only 2 arguments.

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi claret_mug ,

     

    Check the formula below. "&&" as "and", "||" as "or".

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

     

    Best Regards,

    Jay