Forum Discussion

lravikiran's avatar
lravikiran
Icon for Helper I rankHelper I
4 years ago

Ranks displayed wrong when displayed using the Sheet as Tooltip, Interaction as filters

Hi Everyone,

 

 I happen to be facing a very strange issue. I have created a simple Visual with One Bar Graph,A Table and a Card visual. 

 

 

 

Data Model : I have used one fact and One dim table

 

The issue is that the ranks seems to appear correctly on the table , but when i hover on any bar or Select on any Bar or any single Parent Client Code the ranks seems to not show up correctly.

 

 

 

Formula i have used :

 

Client Cost Rank =

RANKX(ALL('Dimension vwClient'[Client Parent Code]),[Cost Measure],,DESC,Dense)

 

 

Cost Measure = SUM('Fact vwClientProfitability'[Cost])

 

 

I have attached PBIX for you ref with Dummy data. Please help me .

amitchandak , almohalhel1408 Greg_Deckler 

 

 

 

 

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    lravikiran , for Rank to be correct you need to have 'Dimension vwClient'[Client Parent Name] in context or as filter, so if that is not there you need to force it.

     

    os if the card visual is not getting filtered it will not give correct rank

    • lravikiran's avatar
      lravikiran
      Icon for Helper I rankHelper I
      4 years ago

      Sorry amit , that was wrong dax with the wrong Coloumn. Updated the dax now.

      • v-kkf-msft's avatar
        v-kkf-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi lravikiran ,

         

        I didn't find the PBIX file you shared, could you please share it again?
        What is the error? It shows 4, is this incorrect?

         

         

        Best Regards,
        Winniz