Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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"
)
)
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |