I have an ACTIVITY table and I’m trying count the number of activities that’s associated with USEREMAIL(). I keep getting a list of numbers but I’m looking for a single value. Anyone help with what’s wrong with the below expression? Thanks
COUNT(SELECT(ACTIVITY DATA[ACTIVITY], [EMAIL] = USEREMAIL() ) )
My result is a list like 5, 5, 5, 5, 5, 5, 5, 5,
The result should be a 5.
Let me know what I’m missing in the expression to single out the number.