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