I have created a dashboard for manufacturing department in Power BI. It has two dates per item - Scheduled Start Date and Start Date in the same table. I have a measure which gives me the difference between schedule start and actual start date in days.
I also created another measure using if formula if it started on time using IF function. (IF SCHEDULED START DATE = STARTED DATE, TRUE, FALSE)
However, I need a count of the times it started on time. i.e. If the STARTED ON TIME = TRUE, it started on time and if it’s FALSE, it got delayed.
Can someone guide me on the best way forward to count this and display on the table?