Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Megasxlr13
New Member

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. (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.

Megasxlr13_0-1697434505987.png

 

 

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

1 ACCEPTED SOLUTION
Abhinav054
Helper I
Helper I

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

View solution in original post

2 REPLIES 2
Abhinav054
Helper I
Helper I

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

Hi Thanks this works

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.