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.
Hello,
How can I write a measure that if the value to be 0 to return it as No Value rather than Blank.
Scenario:
I have Three tables Request ID, Priority, and Technician. The slicer is already set to show only those Request IDs assigned for that technician.
How can I write a measure to show a specific priority for that technician and if there isn't any assigned to him this month - to return 0 or a text "No Value"
I have tried the following but it kept giving me an error:
Solved! Go to Solution.
@Anonymous I don't know, seems to work. See attached PBIX file below sig, Page 16
@Anonymous , +0 can help typically
Try like
Assigned_P4 = if(ISFILTERED('Priorities'[Request ID]), FIRSTNONBLANK('Priorities'[Priority],0)+0, 1)
Hi,
I think the if is the solution
if((valueanalysie)=0,"No Value",value)
@Anonymous Try:
Assigned_P4 =
VAR __Calc = <some calculation>
RETURN
IF(ISBLANK(__Calc),0,__Calc)
or
Assigned_P4 =
VAR __Calc = <some calculation>
RETURN
IF(ISBLANK(__Calc),"No value",__Calc)
or
Assigned_P4 =
VAR __Calc = <some calculation>
RETURN
__Calc + 0
What is the error? Sample data would help.
Which one works will depend on data type of __Calc
This doesn't work or perhaps I wasn't able to replicate it on my file
Created Time | Request ID | Technician | Status | Priority |
02/06/2020 | 100100 | A | Open | P4 |
15/04/2020 | 100101 | B | Open | P1 |
30/05/2020 | 100102 | C | Awaiting Customer Feedback | P4 |
26/06/2020 | 100103 | D | Closed | P2 |
17/18/2020 | 100104 | A | Open | P2 |
17/18/2020 | 100105 | B | Closed | P4 |
14/09/2020 | 100106 | C | Open | P4 |
14/09/2020 | 100107 | D | Closed | P4 |
14/09/2020 | 100108 | A | Awaiting Customer Feedback | P2 |
14/09/2020 | 100109 | A | Closed | P1 |
They're in separate tables but I have already done the relations between tables and calendar and it's working fine.
Let's say I have the above sample and I require to add
number of Completed Problems Assigned
number of Current Problems assigned
@Anonymous I don't know, seems to work. See attached PBIX file below sig, Page 16
@Anonymous You need an extra closing paren ")" at the end of your first row.
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |