Forum Discussion

Megasxlr13's avatar
Megasxlr13
New Member
2 years ago
Solved

Count duplicate events as one

Hi Everyone I have a database named (CUST_DELAY_AND_DOWN_TIME_SUMMARY) that have the following columns in it: 1. (SHIFT_DATE) This is the date. 2. (EQUIP_IDENT) This is the equipment ID. 3. (ST...
  • Anonymous's avatar
    Anonymous
    2 years ago

    hii, you can use the below code

    Count Unique Events = COUNTROWS( CALCULATETABLE(
                                                                              CUST_DELAY_AND_DOWN_TIME_SUMMARY, FILTER(                                                                                                      ALL(CUST_DELAY_AND_DOWN_TIME_SUMMARY),                                               CUST_DELAY_AND_DOWN_TIME_SUMMARY[EQUIP_IDENT] =                                                                                                      EARLIER(CUST_DELAY_AND_DOWN_TIME_SUMMARY[EQUIP_IDENT]) &&                                             CUST_DELAY_AND_DOWN_TIME_SUMMARY[STATUS_DESC] =                                                                                                       EARLIER(CUST_DELAY_AND_DOWN_TIME_SUMMARY[STATUS_DESC]) )                  )
    )