The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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"
)
)