Forum Discussion

CAPEconsulting's avatar
CAPEconsulting
Helper III
9 years ago

RANKXX Issues

I have multiple data tables in a relationship like 

Then on my dashboard I have the following set up

 

The chart at the bottom is juts the values.

And the column chart in the middle is a rank based chart that uses 2 meaures: -

1. RankingH SA3 = SUM('SA3-MH Care'[Value])

2. Rank SA3 = RANKX(ALLSELECTED('SA3-MH Care'), [RankingH SA3],,DESC,Skip)

 

All works well.

 

However when I make a selection of a region, the bottom chart filters through to the correct small areas and shows the right data.

But the ranking chart does not filter down to the right areas and apart from the right areas all areas have the same rannking

 On scrolling to the right you see that the right areas are being ranked but why are the other areas not getting filtered out ?? and why are they being ranked?

Any advise guys??

 

Also any ideas for doing clever visualisation of rankings???

 

Abhijeet

 

Need Help

8 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Hey,

     

    I'm wondering why you don't wrap both measures in the CALCULATE( ... function), this could explain why something isn't filtered as you expect.

     

    Hope this already helps

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        I'm having a slightly hard time reading the relationship diagram, but ... it looks like sa3byphn isn't sa3-mh care... and therefore slicing on phname isn't impacting?