Show top ranking Product for that month in Tooltip in Line & Clustered Column Chart

[Tob_P]

Hi there,

I have a Line & Clustered Column Chart that details Sales by Month for each Financial Year. I'm able to use my Rank X Measure to show the top Sales Amount for each month rated by the Product Name which sold the most in that month..

However I would like the Name to be output also. Not sure how to do that! Here's my RANKX dax for the Top Ranked Product Amount Measure..

Top Ranked Product Amount =

VAR

RankingContext = VALUES(Nav_Item[Product Name])

RETURN

CALCULATE([Amount Measure],

TOPN( 1, ALL(Nav_Item[Product Name] ), [Amount Measure] ),

RankingContext )

[johnt75 · Accepted solution]

Try

Top Ranked Product Name =
VAR RankingContext =
    VALUES ( Nav_Item[Product Name] )
RETURN
    CONCATENATEX (
        TOPN ( 1, RankingContext, [Amount Measure] ),
        Nav_Item[Product Name],
        ", "
    )

In the case where there are more than 1 product ranked #1 then it will return a comma separated list of each of them

[Tob_P]

@johnt75- Excellent work again John. Worked a treat!