DIFFERENT CATEGORY COUNTER

Syndicate_Admin ,

refer add sub group index

https://www.youtube.com/watch?v=7CqXdSEN2k4

Hi, Syndicate_Admin 

 

You can try the following methods. First add a column index to the power query.

Count = 
CALCULATE (
    COUNT ( 'Table'[Category] ),
    FILTER (
        'Table',
        [Category] = EARLIER ( 'Table'[Category] )
            && [Index] <= EARLIER ( 'Table'[Index] )
    )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.