Top N Not Working on Percentage

[Anonymous]

I have a table with contracts, the avg number of employees, and the annualized total turnover. I want to filter it to contracts with 10-15 employees and I want to get the top 10 contracts based on the Annualized Total Turnover (Labeled on the data field as "Avg Vol + Invol TO")

When I apply the filter for Top 10, it's showing me much more than 10 results. When I change the filter to Top 5, it shows me no results.

All of my calculations work properly but I am including them below in case there's a change I need to make in the DAX.

Avg Vol+Invol TO = ((((sum('Step 10 - Master Reporting Table'[CNT - Vol Terms])+sum('Step 10 - Master Reporting Table'[CNT - Invol Terms]))/[Avg Active Count])/[Months Count])*12)

Avg Active Count = (sum('Step 10 - Master Reporting Table'[CNT - Active Count]))/[Months Count]

Months Count = DISTINCTCOUNT('Step 10 - Master Reporting Table'[Reporting Month])

The screenshot on the right includes the filters in the "Filters on this visual" section of the menu.

[Ignore the part of the screenshot that says "is greater than or equal to 15". That was supposed to be "less than or equal to 15". The problem still exists when I change that.]

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may try RANKX to add a measure, then take advantage of Visual level filters and Show items with no data in Power BI.

[Anonymous]

Thank you @v-chuncz-msft . Sorry for the delay in responding. My manager needed me to focus on another project last week.

I tried using the rankx but I must be doing something wrong. See the table below. It is supposed to rank the Annualized Vol TO %

[Assume the header below should say "RANK Vol Turnover"]

There are my formulas:

RANK Vol Turnover = RANKX('Step 10 - Master Reporting Table',[Avg Vol TO],0,DESC,Skip)

Avg Vol TO = (((sum('Step 10 - Master Reporting Table'[CNT - Vol Terms])/[Avg Active Count])/[Months Count])*12)

[Anonymous]

Can anyone help with this? I still have not figured it out.

[Anonymous]

Does anyone have a solution to this? The tool is not working as expected.