Finding Number of Customers who played a video at least once

[davidbd]

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

[ERD · Accepted solution]

@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" }
)