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 trying to use has the following symbol next to it, which seems to be stopping me using the the example formula below... I cannot find my fields this way.

 

 

Measure = SWITCH(TRUE();
[NumberOfUsers] < 250; "SME";
[NumberOfUsers] < 1000 ; "Corporate";
[NumberOfUsers] < 5000 ; "Enterprise";
[NumberOfUsers] >= 5000 ; "Global";
BLANK())

 

Am I missing the point? 

 

Thanks for your help!

 

Mark

3 Replies

  • 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

      Apologies - I should have read that post first. I will have a read shortly.

       

      I get the attached error below when trying to use your formula, which I know is becuase I didn't explain myself properly but I am unable to share the actual data and so used another example, but forgot to clarify the data type...

       

       

      This is the sort of thing I am trying to do, with the correct table name etc

       
      Enrollment = SWITCH(TRUE(),SUM([Enrollment Number]) = "60077216","TEXT","87809449","TEXT2",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.