topic Re: Count duplicate events as one in DAX Commands and Tips

Count duplicate events as one

Megasxlr13 — Mon, 16 Oct 2023 05:39:49 GMT

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.

Re: Count duplicate events as one

Anonymous — Mon, 16 Oct 2023 06:02:30 GMT

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

Re: Count duplicate events as one

Megasxlr13 — Mon, 16 Oct 2023 06:43:08 GMT

Hi Thanks this works