How to rank by different criteria and develop visual for the 2nd value?

[questions]

I would like to develop an visual to identify the weekly trend for the 2nd top mapping in different weeks by Region eg. Gamma. in Asia region in Week 1, 2 & 3

Would you please explain 1) How to rank by the criteria by region & Week 2)develop the weekly trend for the 2nd top mapping?

summary:

[questions]

I would like to develop an visual to identify the weekly trend for the 2nd top mapping in different weeks by Region eg. Gamma. in Asia region in Week 1, 2 & 3

Would you please explain 1) How to rank by the criteria by region & Week 2)develop the weekly trend for the 2nd top mapping?

summary:

[parry2k]

@questions look at this post which explains the ranking.

[questions]

Thanks for sharing the above as the solution for the 1st question. However, how can I identify the 2nd rank in another visual? (which i ask in 2nd questions)

[parry2k]

@questions can you explain what exactly you are looking in 2nd question?

[questions]

@parry2k 

I want to develop a visual to show the performance trend of the 2nd highest value item (can be Gamma in week 1 or Beta in week 3 depend on which week the audience select)...so if audience view the week 3 report, the graph will show Beta week 1-3 trend.If audience view week 1 report, the graph will show Gamma week 1 -3 trend.

[v-frfei-msft · Accepted solution]

Hi @questions ,

To create two measures as below and put the Rank Measure in a matrix

total = CALCULATE(SUM(Table1[Amount]))

Rank = 
IF (
    ISINSCOPE ( Table1[Mapping] ),
    RANKX ( ALL ( Table1[Mapping] ), [total],, DESC, DENSE ),
    BLANK ()
)