Forum Discussion
Solved
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 ...
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.
Fowmy
Super User
Super Userclaret_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 š