Measure always showing Top 5 value when used in Tooltip but works fine when used as table

[Balakrishnan_J]

Max_Sale_Product =

VAR TopN_Table =

        TOPN(

        SELECTEDVALUE(TopNTable[Value],5),

        Products,

        [Total_Sales]

        )

VAR TopN_Product =

    CONCATENATEX(

        TopN_Table,

        Products[Product] & " | " & FORMAT([Total_Sales], "₹ #,#"),

        UNICHAR(10),

        [Total_Sales],

        DESC

    )

RETURN

    IF(

        [Total_Sales] <> BLANK(),

        TopN_Product &

        UNICHAR(10) & "----------" & UNICHAR(10) &

        "Total = " & FORMAT(CALCULATE([Total_Sales], TopN_Table), "₹ #,#")

    )

 1.Normal table using slicer

2.Tooltip

Question:

When the Max_Sale_Product measure is used in table it is working fine when selecting top 1 or top 5 value in slicer but when the same measure in used against tooltip it is always showing top 5 value. Why?
Hi community members need your help?

[Balakrishnan_J]

Hi @Akash_Varuna ,
Its working. Thanks for the solution.

[Akash_Varuna · Accepted solution]

Hi @Balakrishnan_J  , 

The issue occurs because tooltips in Power BI often ignore slicer context.

1. Ensure Slicer Context Propagates
   Add the slicer field (TopNTable[Value]) to the tooltip page and ensure it filters the tooltip.

2. Use IsInScope in the Measure
   VAR TopN_Value = IF(ISINSCOPE(TopNTable[Value]), SELECTEDVALUE(TopNTable[Value], 5), 5)

3. Separate Tooltip Logic
   Create a tooltip-specific measure with a fixed or parameter-based TopN value.
   If this post helped please do give a kudos and accept this as a solution
   Thanks In Advance