Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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())
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())
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |