Forum Discussion

claret_mug's avatar
claret_mug
Frequent Visitor
5 years ago
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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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's avatar
claret_mug
Frequent Visitor
5 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

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!