Measure not working as intented

[lotus22]

I have the following calculation and the table. For some reason, LO is not showing on for FTT% by Weld. I know why because the Fail calculation is zero. I do not how to show it on the graph as red because the weld has failed.

Part Number	Manufacturing Date:	Manufacturing Time:	F/O, M/O, L/O, Adjustment:	Weld Number	Pass/Fail	weeknumber
ABC	5/9/2021	1:00 PM	MO	WELDA	Pass	20
ABC	5/9/2021	10:00 PM	LO	WELDA	Pass	20
XYZ	5/9/2021	10:00 PM	LO	WELDA	Failed	20
XYZ	5/9/2021	4:20 AM	Adjustment	WELDA	Pass	20
XYZ	5/9/2021	1:00 PM	MO	WELDA	Pass	20
Measures
	Pass = calculate(count('Attribute Data'[Weld Number]),'Attribute Data'[Pass/Fail]="Pass")
	Fail = calculate(count('Attribute Data'[Weld Number]),'Attribute Data'[Pass/Fail]="Failed")
	FTT% By Welds = (Divide([Pass],([Pass]+[Fail])))
	color = if([FTT% By Welds]<1,"Red","Green")

As you can see below LO is not showing up on the graph for Weld "Weld A" and Part number XYZ

[nilimarodrigues · Accepted solution]

Hello,

What if you update your FTT% By Welds formula to below:

FTT% By Welds = if(Divide([Pass],([Pass]+[Fail]))=0,0.00001,Divide([Pass],([Pass]+[Fail])))

Basically, you are giving a dummy value 0.00001 in case the division is going to result in value 0. That way, LO can be plotted on the chart:

Kindly give Kudos if my reply helps!

Thanks