Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating a funnel chart from a derived table

Hi Folks, I'm trying to build a funnel chart, but the requirement is bit specific. Let me explain the requirement.    Following are the different Funnels steps: Step 1: "Access Step": It's the fi...
Anonymous's avatar
Anonymous
Not applicable
2 years ago
Check New User Step = CALCULATE(
    DISTINCTCOUNT('Bookings Funnel Data_RAW'[UserId]),
    FILTER(
        'Bookings Funnel Data_RAW',
        'Bookings Funnel Data_RAW'[EventName] = "NewUserEvent" && // Replace "NewUserEvent" with the actual event name for new users
        'Bookings Funnel Data_RAW'[UserId] IN VALUES('Bookings Funnel Data_RAW'[UserId])
    )
)

This solution worked for the 2nd Step. Thanks!