Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago
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])
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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 👍