Forum Discussion

Black3y's avatar
Black3y
Microsoft Employee
6 years ago
Solved

DAX IF/THEN Statement

Hi all,   I am trying to do a very simple measure to look at a field and simply create an IF "this" then "This" to basically relate what it currently a number to a Customer Name.  The field I am tr...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    First, 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

     

    Second, that is the symbol for a measure.

     

    Third, guessing that [NumberOfUsers] is a column, you will need to use aggregation like so:

     

    Measure = SWITCH(TRUE();
SUM([NumberOfUsers]) < 250; "SME";
SUM([NumberOfUsers]) < 1000 ; "Corporate";
SUM([NumberOfUsers]) < 5000 ; "Enterprise";
SUM([NumberOfUsers]) >= 5000 ; "Global";
BLANK())
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

First, 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

 

Second, that is the symbol for a measure.

 

Third, guessing that [NumberOfUsers] is a column, you will need to use aggregation like so:

 

Measure = SWITCH(TRUE();
SUM([NumberOfUsers]) < 250; "SME";
SUM([NumberOfUsers]) < 1000 ; "Corporate";
SUM([NumberOfUsers]) < 5000 ; "Enterprise";
SUM([NumberOfUsers]) >= 5000 ; "Global";
BLANK())
Black3y's avatar
Black3y
Microsoft Employee
6 years ago

I also appear to have copied the wrong symbol, which seems to be the reason i can't do a simple "IF" command on that field... See below what I meant to show you.

 

 

I am simply trying to create a measure that will look at the field "Enrollment Number" and search for certian strings, when it finds one then return a new Value. So for example if it finds "1098333" I want to return "BOB" into the new measure.

 

Mamy thanks for your support.