Forum Discussion
Count duplicate events as one
- Anonymous2 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]) ) )
)
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]) ) )
)
- Megasxlr132 years agoNew Member
Hi Thanks this works