SUM IF

[M_SBS_6]

Hi, 

How would I write the following correctly in DAX please

If(

comp[status] = "seg"

and comp[value] <100, 0

else

comp[total_amount])

[DOLEARY85 · Accepted solution]

Hi,

a calculated column with the DAX below should work:

Column = if(and(comp[status] = "seg",comp[value]<100),0,comp[total amount])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍