Forum Discussion

CMajka8's avatar
CMajka8
Helper 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. This should include company ABC where product = Fire. 

 

thank you

Need Help

1 Reply

  • vk_pbi's avatar
    vk_pbi
    Resolver 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"
	)
)