ignore values less than zero

Hi eburke

You should be able to use the IF function for this.

= IF ([Customer Assigned] - [PrePaid] < 0 , 0 , [Customer Assigned] - [PrePaid] )

HI eburke

Just wrap a SUMX Function around it to force the Total calc to be row by row

Measure 2 = 
	SUMX(
		'Table2',
		IF(
			'Table2'[Customer Assigned]-'Table2'[Pre Paid]>0,
			-- THEN --
			'Table2'[Customer Assigned]-'Table2'[Pre Paid],
			-- ELSE --
			0)
			)

When I try this formula the THEN and ELSE come up green like Power BI doesn't recognise it as a function.  Also will it matter that the Customer Assigned and PrePaid Meaures are on different tables?  Thanks,