Forum Discussion
Returning a value
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 alr...
Anonymous I don't know, seems to work. See attached PBIX file below sig, Page 16
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.