Counting occurence of customer ID

[goodbecenergy]

Hello & thanks in advance for your help. 

I have a table of responses from the website which has been anonymised so for each line there is a unique User ID.

I'm trying to count frequent flyers and show the messages for the person who has been in contact the most.

I have tried: 

ID_Count = CALCULATE(COUNTROWS(hotjar),FILTER(hotjar,hotjar[ID_User]<>""))

ID_No of Ref = CALCULATE(

    COUNT(hotjar[ID_User ID]),

    FILTER(hotjar,hotjar[ID_]= EARLIER(hotjar[ID_User ID])))  - which is the closest so far

I've also tried COUNTROWS in various iterations

Once I have the number, I would also like a table showing the messages of the highest frequent flyer. 

Thanks again

[goodbecenergy · Accepted solution]

I managed to find a way to get around this... by using a table rather than a chart. Thanks for all the suggestions

[v-yangliu-msft]

Hi  @goodbecenergy ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

If convenient, you can show your expected results in the form of pictures, and we can help you better.

Best Regards,

Liu Yang

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

[goodbecenergy]

So I know that the ID_No of Ref column is correct but it isn't counting 2 entries because 2 were submitted in the same day...twice. 

I've managed to create the table by including the date and unique reference number then using the column as a filter showing Top 1 by ID_No of Ref.

But yeah.. how to count two entries on one day please.