undefined

athersh,

 

Try a measure like this:

 

Clients with over 100 tickets =
VAR vTicketCount =
    ADDCOLUMNS (
        VALUES ( Table1[Client] ),
        "@Count", CALCULATE ( COUNT ( Table1[Ticket ID] ) )
    )
VAR vResult =
    COUNTROWS ( FILTER ( vTicketCount, [@Count] > 100 ) )
RETURN
    vResult

Hi athersh 

 

DataInsights Good share!

 

For your question, here is the method I provided:

 

Here's some dummy data

 

"Table"

 

Create measures.

 

 

count_ticket_number = 
    CALCULATE(
        DISTINCTCOUNT('Table'[Ticket Number]), 
        FILTER(
            ALL('Table'), 
            'Table'[customer ID] = MAX('Table'[customer ID])
        )
    )

 

 

 

 

count_customer_100 = 
    CALCULATE(
        DISTINCTCOUNT('Table'[customer ID]), 
        FILTER(
            ALL('Table'), 
            [count_ticket_number] > 5 // Change the judgment condition to be greater than 100
        )
    )

 

 

Here is the result.

 

If you still have problems, please provide some dummy data and desired results. It is best presented in table form.

 

Regards,

Nono Chen

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