Forum Discussion
using OR in a measure
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.
Community Championclaret_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 🙂