Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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"
)
)