How to do it...

To craft a funnel drop-off rate, do the following:

1. Create the following measure:

Drop Off Rate = 
    VAR __CurrentStep = MAX([Step])
    VAR __PreviousStep = __CurrentStep - 1
    VAR __CurrentCount = COUNTROWS('R01_Table')
    VAR __PreviousCount = 
        IF(
            __CurrentStep = 1 , 
            0 , 
            COUNTROWS(FILTER(ALL('R01_Table'),[Step] = __PreviousStep ))
        )
RETURN
    DIVIDE(__CurrentCount - __PreviousCount, __PreviousCount, 0)

2. Format Drop Off Rate as a percentage.
3. On a report page, create a Funnel visualization and place the Page column from R01_Table into the Group area of the visualization.
4. In the same visualization, place the Page column from R01_Table into the Values area of the visualization and ensure that the summarization is set to Count.
5. In the same visualization, place the Drop Off Rate measure into the Tooltips area of the visualization.