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

[lravikiran]

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 

[amitchandak]

@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]

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

[v-kkf-msft]

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