Forum Discussion

spandy34's avatar
spandy34
Responsive Resident
3 years ago
Solved

Count filtered time fields

I was wondering if you could help me please.  I want to create a measure called z_15min Commission the counts all the SSRef fields where there is   00:15:00 in the Planned Duration field.  Planned Du...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

     

    z_15min Commission = CALCULATE(
   COUNTA('Procurement_Main_Data'[SSRef]), 
     'Procurement_Main_Data'[Planned Duration]>= TIMEVALUE("00:00:00")​&&
    'Procurement_Main_Data'[Planned Duration]<= TIMEVALUE("00:17:00")
)

     

     

  • Ahmedx's avatar
    Ahmedx
    3 years ago

    no need to copy measure and paste. must be written by hand

spandy34's avatar
spandy34
Responsive Resident
3 years ago

Hi no . I want to Count SSRef where the 'Procurrment Main Data'[Planned Duration] is between 00:00:00 and 00:17:00

 

thank you 

Ahmedx's avatar
Ahmedx
Super User
3 years ago

 

z_15min Commission = CALCULATE(
   COUNTA('Procurement_Main_Data'[SSRef]), 
     'Procurement_Main_Data'[Planned Duration]>= TIMEVALUE("00:00:00")​&&
    'Procurement_Main_Data'[Planned Duration]<= TIMEVALUE("00:17:00")
)

 

 

  • spandy34's avatar
    spandy34
    Responsive Resident
    3 years ago

    I get this error message

     

     

    • Ahmedx's avatar
      Ahmedx
      Super User
      3 years ago

      no need to copy measure and paste. must be written by hand

      • spandy34's avatar
        spandy34
        Responsive Resident
        3 years ago

        Thank you - your a star 

  • spandy34's avatar
    spandy34
    Responsive Resident
    3 years ago

    Hi Ive solved it - I put a space before && and its worked.

     

    Thank you so much for your help Ahmedx