Distinct count how many users failed repeatedly

Hello aidelapplicate,

I think i understand your issue and have created a powerbi report based on your example data set.

I got the following results while trying to create what you described:

I hope this is what you are looking to do.

I have created this using the following two measures:

failed count = 
CALCULATE(
    COUNT(Data[User]),
    Data[sales] < 100
)

repeater = 
IF( 
    [failed count] > 1,
    CALCULATE(
        COUNT(Data[User]),
        Data[sales] < 100
    ),
    BLANK()
)

You can download my pbix file here: download pbix file 

Hope this helps.

If this solved your problem, please give a thumbs up and mark this answer as your solution 🙂

Have a nice day!