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 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:
Anonymous I don't know, seems to work. See attached PBIX file below sig, Page 16
8 Replies
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 + 0What 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
Hi,
I think the if is the solution
if((valueanalysie)=0,"No Value",value)
Anonymous , +0 can help typically
Try like
Assigned_P4 = if(ISFILTERED('Priorities'[Request ID]), FIRSTNONBLANK('Priorities'[Priority],0)+0, 1)
