Count duplicate events as one

[Megasxlr13]

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. (STATUS_DESC) This is the event description.

Events are loged per equipment, some events are sorted in on shift and counted as a single event. If the event last more than a shift it is loged as a new event with the same description and a consecutive shift date meanig for a day it is 3 events. I need to have this event be counted as one.

If anyone can help me whit this it will be much apriciated.

[Abhinav054 · Accepted solution]

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]) )                  )
)

[Megasxlr13]

Hi Thanks this works