Get number of records per group and filter

[abalgir]

Hi,

I am looking for a fairly simple measure. I have a table where I have Trade_ID. For the same trade ID I might have different activities , for example:

Tradee_ID   Activity 

10009         New

10009         Modified

10009         Canceled

10098         Matched

10098         Validated

10989         New

10989         Matched

78909         New

What I want is the following: a measure that returns how many trade_id  for which the number of activities is > 1 

I should have 3 in my case ( I have 3 trade_id where they have more than 1 activity each)

How do I achieve this?

Many thanks

[d_gosbell · Accepted solution]

You could do this with a measure like the following that loops over all the distinct Tradee_ID values and checks if the count of Activity values is greater than 1

Measure = SUMX(DISTINCT('Table'[Tradee_ID]), IF(COUNTROWS(CALCULATETABLE(VALUES('Table'[Activity]))) > 1,1))

[abalgir]

Thank you it worked. sorry for the late reply. I appreciate