cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

## 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

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" )
1 ACCEPTED SOLUTION
Super User

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

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
4 REPLIES 4
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 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up
Super User

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

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

@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 🙂

Super User

@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!

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...