Card with average count excluding 1's

[avotius]

Hello, my dataset is customer service data with a date, thread id, subject, and message. Every time there is a message a new row is populated, and if it was part of an ongoing message the thread id is the same.

What I am trying to do is make a card that will count the amount of messages in a thread, then give me an average of all threads, but exclude any thread where the count is 1 as that would be a new thread that has not been touched. 

I made a quick measure and this is what it gave me, but I can't use the filter on the visual for "show items when value..." as the drop down does not work and the input box is greyed out. Any ideas? Thanks!

Average ThreadId =

AVERAGEX(

    KEEPFILTERS(VALUES('CareConvos'[ThreadId])),

    CALCULATE(COUNTA('CareConvos'[ThreadId]))

)

[avotius]

Thanks a million Pat! That actually worked perfectly. Now I am going to pick it apart and try to figure out why it works!

[mahoneypat · Accepted solution]

I would try a measure like this one.

Avg Messages Per Thread =
VAR summary =
    SUMMARIZE (
        'CareConvos',
        'CareConvos'[ThreadId],
        "cCount", COUNT ( 'CareConvos'[ThreadId] )
    )
RETURN
    AVERAGEX ( FILTER ( summary, [cCount] > 1 ), [cCount] )

Pat