topic DAX IF/THEN Statement in DAX Commands and Tips

DAX IF/THEN Statement

Black3y — Thu, 02 Apr 2020 13:46:00 GMT

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

Re: DAX IF/THEN Statement

Greg_Deckler — Thu, 02 Apr 2020 14:35:12 GMT

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())

Re: DAX IF/THEN Statement

Black3y — Thu, 02 Apr 2020 15:10:34 GMT

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())

Re: DAX IF/THEN Statement

Black3y — Thu, 02 Apr 2020 20:26:00 GMT

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.