Measure not working as intented

Question

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.&nbsp;Part NumberManufacturing Date:Manufacturing Time:F/O, M/O, L/O, Adjustment:Weld NumberPass/Failweeknumber&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC5/9/20211:00 PMMOWELDAPass20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC5/9/202110:00 PMLOWELDAPass20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ5/9/202110:00 PMLOWELDAFailed20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ5/9/20214:20 AMAdjustmentWELDAPass20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ5/9/20211:00 PMMOWELDAPass20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Measures&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Pass = calculate(count('Attribute Data'[Weld Number]),'Attribute Data'[Pass/Fail]="Pass")&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fail = calculate(count('Attribute Data'[Weld Number]),'Attribute Data'[Pass/Fail]="Failed")&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FTT% By Welds = (Divide([Pass],([Pass]+[Fail])))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;color = if([FTT% By Welds]&lt;1,"Red","Green")&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;As you can see below LO is not showing up on the graph for Weld "Weld A" and Part number XYZ&nbsp;&nbsp;

nilimarodrigues · Accepted Answer

Hello,&nbsp;What if you update your FTT% By Welds formula to below:&nbsp;FTT% By Welds = if(Divide([Pass],([Pass]+[Fail]))=0,0.00001,Divide([Pass],([Pass]+[Fail])))&nbsp;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:&nbsp;&nbsp;Kindly give Kudos if my reply helps!&nbsp;Thanks

Forum Discussion

Measure not working as intented

1 Reply

Related content

Policy Update: How configured property Managed Intentity

Access to queryinsights.sql_pool_insights in Fabric Warehouse – intentional restriction?

OneLake Security support for Fabric Warehouse - planned roadmap or intentional limitation?

New Measure Thrashes Table but Measure Proven to Work

Measure is not working

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")