Forum Discussion
Solved
SUM IF
Hi, How would I write the following correctly in DAX please If( comp[status] = "seg" and comp[value] <100, 0 else comp[total_amount])
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 👍
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 👍