Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
davidbd
Regular Visitor

Finding Number of Customers who played a video at least once

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

1 ACCEPTED SOLUTION
ERD
Super User
Super User

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

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

Check out my latest demo report in the data story gallery.

Stand with Ukraine!


Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

View solution in original post

1 REPLY 1
ERD
Super User
Super User

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

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

Check out my latest demo report in the data story gallery.

Stand with Ukraine!


Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.