Dropdown Percentage Calculation

Hello,
How could the drop down percentage be calculated like mentioned in the Funnel chart?

Event_name 2022-09 Dropdown Percentage
Visits on Portal 456 100%
Sign up CTA Click_Login Page_Product 230 50.44
Register CTA Click_Registration Page_Product 200 43.86%
View and confirm email 176 38.6%
Activate Link CTA Click_popup_Product 56 12.28%
Sector and Subsector 54 11.84%
Accounting Software 30 6.58%
Intuit SSO 25 5.48%
Link Activation 18 3.9%

Dropdown_Percentage.pbix (25.6 KB)

@Dhrumil212

Measure = 
DIVIDE ( 
    MAX ( 'Table'[2022-09] ),
    CALCULATE ( 
        MAX ( 'Table'[2022-09] ), 
        ALLSELECTED ( 'Table' ) 
    )
)
2 Likes

Hello @Dhrumil212

Did the response from @AntrikshSharma help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you