Forum Discussion

CMajka8's avatar
CMajka8
Icon for Helper II rankHelper II
3 years ago

DAX Measure with multiple conditions

Hello -    I am trying to write a measure that includes multiple conditions. I essentially need it to calculate a sum:   Premium = sum all premiums but exclude company ABC where Product = Auto. T...
Need Help
vk_pbi's avatar
vk_pbi
Icon for Resolver II rankResolver II
3 years ago

Hi CMajka8 

I assumed, all are in single table, if not please provide table details or data model

CALCULATE(
	SUM('Table1'[Premium amt]),
	FILTER(
		'Company',
		'Company'[Product] <> "Auto" &&
		'Company'[Product] = "Fire"
	)
)