Finding Number of Customers who played a video at least once

davidbd — Fri, 02 Dec 2022 21:09:12 GMT

I am looking through the progression of pages users clicked on within one of our apps. Customers can go backwards in the process and each action has a time stamp. I want to find the percentage of customers who played a protection plan video at least once

ActivityType: page title (can visit the same page more than once) Interested in "Products Presented" (Main protection plan page) and "Product Video Viewed" ConsumerID: customers unique identifier EventDateTime: Timestamp for each page visit

Is there a way to count CustomerId that played at least one video?

DistinctCustomersPlayedVideo = 
CALCULATE(
    DISTINCTCOUNT(ConsumerFunnelTime[ConsumerID],
    COUNT(ConsumerFunnelTime[ActivityType] IN {"ProductVideoViewed"} >= 1))
)

I can then divide this by the number of distinct customers that made it to the protection page at least once

Re: Finding Number of Customers who played a video at least once

ERD — Sat, 03 Dec 2022 09:10:38 GMT

davidbd , usually it's better to provide a small data sample..

Anyway, I'd start from the syntax mistakes:

DistinctCustomersPlayedVideo = CALCULATE ( DISTINCTCOUNT ( ConsumerFunnelTime[ConsumerID] ), ConsumerFunnelTime[ActivityType] IN { "ProductVideoViewed" } )

topic Re: Finding Number of Customers who played a video at least once in DAX Commands and Tips

Finding Number of Customers who played a video at least once

Re: Finding Number of Customers who played a video at least once