Forum Discussion
using OR in a measure
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
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.
4 Replies
- Fowmy
Super User
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 🙂
- Greg_Deckler
Community Champion
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.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!
