Error

[Anonymous]

Hi @Killness ,

Please allow me to explain the reason for this issue. When you drill down, the result only displays the selected ZONAMERCADO. Regardless of which ZONAMERCADO you choose, the result is a single record, so its rank will always be 1.

As a solution, I recommend creating a calculated table that links to the original table. In this calculated table, you can create a new column to calculate the rank value and display this rank in the tooltips. This approach ensures that the rank remains accurate, as it won’t be dynamically affected by the drill-down process.

I’ve a test for your reference:

1\My data source:

FOBPRODUCTOR

2\Crate a calculate table:

NewTable =

ADDCOLUMNS(

    SUMMARIZE(

        ALL(FOBPRODUCTOR),

        FOBPRODUCTOR[ZONAMERCADO],

        "TotalValue", SUMX(FOBPRODUCTOR, FOBPRODUCTOR[Value])

    ),

    "Ranking", RANKX(

        SUMMARIZE(

            ALL(FOBPRODUCTOR),

            FOBPRODUCTOR[ZONAMERCADO],

            "TotalValue", SUMX(FOBPRODUCTOR, FOBPRODUCTOR[Value])

        ),

        [TotalValue], , DESC, DENSE

    )

)

3\ model view

4\Tooltips page

5\Result

Best Regards,

Bof

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Not sure how much i can help but i would like to try.