using OR in a measure

[claret_mug]

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

[Fowmy]

@claret_mug 

Try:

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" || AND([Entry Qualification Mapping] ="Mixed BTEC","A-Levels") 
)   

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Greg_Deckler · Accepted solution]

@claret_mug Maybe:

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 ",
    OR(Table1[Entry Qualification Mapping] = "BTEC Only", Table1[Entry Qualification Mapping] = "Mixed BTEC and A-Levels")
)

If not, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[claret_mug]

@Greg_Deckler thank you so much, this has worked. I was putting the 'OR' in the wrong place when I attempted it. Thanks for saving me from an afternoon of pain 🙂 

[Greg_Deckler]

@claret_mug - No problem. @Fowmy 's solution should work as well. Double pipe ( || ) is an OR operator and probably works like you were expecting OR function to work!