Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Thank You
MM
Solved! Go to 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])
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])
Thank you this worked!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |