So using RANKX I am showing the lowest net revenue locations and in another table the highest net revenue locations. The problem is instead of showing the Lowest 10, it only shows the lowest 8 and I cannot figure out why it stops at 8 instead of showing 10.
My Lowest Net Revenue Formula is:
Lowest Net Revenue = VAR RankingDimension = VALUES( 'WW Fiscal Locations'[Fiscal Location Name]) VAR RankingSelect = [Lowest Ranking Select] RETURN CALCULATE( [Net Revenue], FILTER(RankingDimension, RANKX(ALL('WW Fiscal Locations'[Fiscal Location Name]), [Net Revenue], , ASC) <= RankingSelect))
Net Revenue is calculated by:
Net Revenue = [Total Revenue from Tuition] - [Overall Expenses]
Lowest Ranking Select is:
Lowest Ranking Select = IF( HASONEVALUE( 'Lowest Ranking'[Lowest Ranking]), VALUES( 'Lowest Ranking'[Lowest Rank Number] ), 1000000) //select the rank number based on slicer selection
My Lowest Ranking Table is as follows:
Of course I had to blur out the actual net revenues but below is the visual. The Highest Net Revenue Locations visual shows a perfect 10 locations as expected but the lowest only shows 8 instead of 10. Is there something that only makes it show lowest if the lowest is negative?