Count Items which occurs again

Hi, I need to create 2 measures. The first one should count how many items occur again today. The second one should tell how many times this particular item occur in the past. Sample data be...

Need Help

Tips and Tricks

v-xuding-msft

5 years ago

Hello @pawelj795 ,

Please try this:

Measure 1 = 
var t1_= 
    CALCULATETABLE (
        VALUES ( 'Table'[Item ID] ),
        FILTER (
            ALL ( 'Table'[Date] ),
            'Table'[Date] < MAX('Table'[Date]) )
        )
var t2_= 
    CALCULATETABLE (
        VALUES ( 'Table'[Item ID] ),
        FILTER (
            ALL ( 'Table'[Date] ),
            'Table'[Date] = MAX('Table'[Date]) )
        )
return
COUNTROWS(INTERSECT(t1_,t2_))

Measure 2 = CALCULATE(COUNT('Table'[Date]),ALLEXCEPT('Table','Table'[Item ID]))

Count Items which occurs again.pbix47 KB

Measure 1 = var t1_= CALCULATETABLE ( VALUES ( 'Table'[Item ID] ), FILTER ( ALL ( 'Table'[Date] ), 'Table'[Date] < MAX('Table'[Date]) ) ) var t2_= CALCULATETABLE ( VALUES ( 'Table'[Item ID] ), FILTER ( ALL ( 'Table'[Date] ), 'Table'[Date] = MAX('Table'[Date]) ) ) return COUNTROWS(INTERSECT(t1_,t2_))

Forum Discussion

Count Items which occurs again