Rank within category and month

[Antmkjr]

Date	Name	Amount
1/19/2022	A	80
1/15/2022	A	100
1/14/2022	B	60
2/14/2022	C	20
2/7/2022	C	40
2/11/2022	A	50
3/14/2022	B	30
3/18/2022	A	20

 In the above sample data, i need to create a pbi report, which shows the ranking of each categories in each month.

So  for Month 2 , will show for Category A,Rank = 2, Category C , Rank=1.

For month = 1, Rank for Category A = 1, Category B =2

[Antmkjr]

Is there any way to improve the performance of the above formula?

[Anonymous]

hello lease use:

Ranking = RANKX( ALLSELECTED( Ranking[Name] ) , CALCULATE( SUM( Ranking[Amount]) ))

 

  

[Jihwan_Kim]

Hi,

Please check the below picture and the attahced pbix file.