Returning a value

[Anonymous]

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: 

Assigned_P4 = if(ISFILTERED('Priorities'[Request ID], FIRSTNONBLANK('Priorities'[Priority],0), 1)))) 

[amitchandak]

@Anonymous , +0  can help typically

Try like

Assigned_P4 = if(ISFILTERED('Priorities'[Request ID]), FIRSTNONBLANK('Priorities'[Priority],0)+0, 1)

[Anonymous]

@amitchandak 

Hey, 

This only keeps returning a 1 

[dobregon]

Hi,

I think the if is the solution

if((valueanalysie)=0,"No Value",value)

[Greg_Deckler]

@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

[Anonymous]

@Greg_Deckler 

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

[Greg_Deckler · Accepted solution]

@Anonymous I don't know, seems to work. See attached PBIX file below sig, Page 16

[Anonymous]

@Greg_Deckler Hi, 

It's not working for some reason - see the screenshot below, please. 

[Greg_Deckler]

@Anonymous You need an extra closing paren ")" at the end of your first row.