Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help on if condition

Hi,

I've below DAX Measure senario need help on this.

if(
CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue")  =0,   
then
CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue",CM[CMLastMonthYear]=1),
Else
0 )
 
Can someone help me on this? 
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Try this

    Measure = IF( CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue") = 0, CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue", CM[CMLastMonthYear] = 1 ), 0 )

    Regards

    Phil

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

    Try this

    Measure = IF( CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue") = 0, CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue", CM[CMLastMonthYear] = 1 ), 0 )

    Regards

    Phil

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

    Try this

    Measure = IF( CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue") = 0, CALCULATE(count(ALL(CM[Change ID])), CM[Overdue / Not overdue] = "Not Overdue", CM[CMLastMonthYear] = 1 ), 0 )

    Regards

    Phil