ranking and TOpN

nadeemrajabali — Wed, 06 Oct 2021 22:42:04 GMT

Hi All,

Need some help.

I have these two measures.

Item Ranking by Total Cost (Selected Range) = 

IF( ISBLANK( [Total Cost] ),

 BLANK (),

 RANKX (

 ALLSELECTED( 'Item'),

 [Total Cost],

 ,

 DESC,

 Skip

 )

)

Top Item Total Cost by Rank = 

VAR

 RankingDimension = VALUES( 'Item'[Item Name] )

VAR

 RankingSelect = 'Ranking Selections'[Ranking Select]

RETURN

IF( ISBLANK([Total Cost]),

 BLANK(), 

 CALCULATE( [Total Cost],

 FILTER( RankingDimension,

 RANKX( ALL('Item'[Item Name]), [Total Cost], ,Desc, SKIp) <= RankingSelect ) )

)

If these measures are used seperately, they are working correctly.

However when include my ranking measure with TOPN Measure. Below is what I get.

Can someone please help me fix the second Matrix?

1) Only selected TOP N are displayed

2) the Ranking is not working correctly, there are some ranks repeated twice however the Totalcost is not exactly same.

Third Question that is a tricky one. Is there a way I can create a Dynamic dropdown slicer from second matrix that shows me the list formatted as below?

Rank | Item Name | Total Cost

Thanks

Re: ranking and TOpN

Greg_Deckler — Thu, 07 Oct 2021 01:21:31 GMT

nadeemrajabali Seems like you need a Complex Selector: The Complex Selector - Microsoft Power BI Community

RANKX can be tricky to work with, particularly as a measure: To *Bleep* with RANKX! - Microsoft Power BI Community

There's a good chance you need a CALCULATE.

topic Re: ranking and TOpN in DAX Commands and Tips

ranking and TOpN

Re: ranking and TOpN