Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

dax for eng =1

hi
i want to show the count of engineer visits = 1 in my dax.
this is the dax that i am using

last MTD engineer visits = Coalesce(CALCULATE(COUNT(Request[Engineer Visits] ),DATESMTD(dateadd('Calendar'[Date],-1,MONTH))),0)

 
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello Anonymous , Try below measure

     

    MTD = CALCULATE(CALCULATE(COUNT(Request[Engineer Visits] ),DATESMTD(dateadd('Calendar'[Date],-1,MONTH)),'Request'[Engineer Visits]=1)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Anonymous , Try below measure

     

    MTD = CALCULATE(CALCULATE(COUNT(Request[Engineer Visits] ),DATESMTD(dateadd('Calendar'[Date],-1,MONTH)),'Request'[Engineer Visits]=1)