Displaying category on rank = 2 only based on sales by categories

[reendzz98]

Hi everyone,

I'm having a problem to display category which rank = 2

Below is the table that I currently have in my report.

For the ranking table, I currently using the measure below:

var a = max(smart_revenue[Year])

return
RANKX( ALLSELECTED(car[car_name]), CALCULATE(SUM(car_sales[sales1]) + SUM(car_sales[sales2]),smart_revenue[Year]=a))

Credit to: @Adam_Shelton for helping me out to create this measure.

I want to create a measure which a scorecard can display car DEF only. Any tips?

[Adam_Shelton · Accepted solution]

Well, there are 2 ways you can try:

1. Using filter on this visual: you can create a visual and apply filter rank = 2

2. Create another DAX: calculate Sales with condition rank measure = 2

[amitchandak]

@reendzz98 , I think the newly released Index function should be a better option

newly released Dax Function Offset, Window, Index: https://youtu.be/KhkCALjHylE