Creating a funnel chart from a derived table

Hi Anonymous 

The following DAX may help you solve your problem:

Step 1: Access Step

You’ve already defined this measure:

Access Step = CALCULATE(
    DISTINCTCOUNT('Bookings Funnel Data_RAW'[UserId]),
    FILTER(
        'Bookings Funnel Data_RAW',
        'Bookings Funnel Data_RAW'[EventName] IN {
            "HasPersonalAccessNotSharedAccess",
            "SharedAndPersonalBookingsAccessible",
            "HasSharedAccessNotPersonalAccess"
        }
    )
)

Step 2: Check New User Step:

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])
    ),
    'Bookings Funnel Data_RAW'[EventName] IN {
        "HasPersonalAccessNotSharedAccess",
        "SharedAndPersonalBookingsAccessible",
        "HasSharedAccessNotPersonalAccess"
    }
)

Step 3: Home Page Interaction:

Home Page Interaction = CALCULATE(
    DISTINCTCOUNT('Bookings Funnel Data_RAW'[UserId]),
    FILTER(
        'Bookings Funnel Data_RAW',
        'Bookings Funnel Data_RAW'[EventName] = "HomePageInteractionEvent" && // Replace with the actual event name for home page interactions
        'Bookings Funnel Data_RAW'[UserId] IN VALUES('Bookings Funnel Data_RAW'[UserId])
    ),
    'Bookings Funnel Data_RAW'[EventName] = "NewUserEvent" // Assuming continuity from the New User step
)

Best Regards,

Jayleny

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