Forum Discussion

jurkowskij's avatar
jurkowskij
Frequent Visitor
3 years ago
Solved

Count customers with On Time Shipment

Hi,   I try to create a measure that count how many customer had their shipment on time (All Shipments on time) in this year   Example data Customer   ExpectShipmentDate   ShipmentDate  ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jurkowskij 

    1.Please check that the data type of your ShipmentDate column or datediff column, whether the type is "Text" instead of "Date" or "Whole number".
    2.You can refer to the following measure

    Measure = var a=SUMMARIZE(
               'Table',
               'Table'[Customer]               
               , "Sum",SUM('Table'[Datediff])
)
return COUNTROWS(FILTER(a,[Sum]=0))

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jurkowskij 

1.Please check that the data type of your ShipmentDate column or datediff column, whether the type is "Text" instead of "Date" or "Whole number".
2.You can refer to the following measure

Measure = var a=SUMMARIZE(
               'Table',
               'Table'[Customer]               
               , "Sum",SUM('Table'[Datediff])
)
return COUNTROWS(FILTER(a,[Sum]=0))

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

jurkowskij's avatar
jurkowskij
Frequent Visitor
3 years ago

It seems to work. thanks a lot