Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
85 | |
80 | |
74 | |
49 | |
41 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |