Help with Conference attendee data

[milkmoneymike]

Hello All
Im pretty new to Power BI and had some questions about a report i am working on, Hopefully this makes sense and is doable. I have the Powe BI file HERE. If it will help with creating this request. Many thanks to anyone who can point me in the right direction. i would like a Count of contact IDs for each show (which i can easily do) but im having issues with these:

• I want to show number of first timers (People who have never been to ANY previous show)
• For the people who have been to a previous confernce how can i show what confernces they HAVE been to?

Thank You 

MM

[amitchandak · Accepted solution]

Create a new columns.

This will count a person appears in any show. You are looking for 1

Times in any show = countx(FILTER(data,data[contactid]=EARLIER(data[contactid]) && data[StartDate]<=EARLIER(data[StartDate])),data[contactid])

In a show how many time

timeS in that show = countx(FILTER(data,data[contactid]=EARLIER(data[contactid]) && data[EventName]=EARLIER(data[EventName]) && data[StartDate]<=EARLIER(data[StartDate])),data[contactid])

[milkmoneymike]

Thank you this worked!