Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rank a Running Total

I'm trying to create a measure that will rank a running total (that's also a measure).   To explain my data, I have the following (It may help to imagine Formula 1 here as my data has a similar str...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak , Unfortunately this hasn't helped - it hasn't gone into elements like running totals, and I think part of my problem is the matrix visual too.

     

    Here's my current problem with some dummy data... I'm using the measure...

     

    RankPointsRunningTotal = RANKX(Results,[PointsRunningTotal],,0,skip)

     

     

    This is producing the following output:

     

    I have a slicer that is filtering the data to just a specific season, containing the 3 weeks in January being displayed (there are also two other tournaments in 2 other seasons which are being successfully filtered out of this page - and out of the measures). The odd thing here is the "Player" Nico Rosberg didn't play in the season being shown. The top visualisation is filtering him out as I'd expect, but the rank visualisation is including him (which it shouldn't). And the Rank's aren't working either. I'm expecting the ouput of the Rank visualisation to look like what's in the spreadsheet.

     

    Here's a link to the file above: https://www.dropbox.com/s/wryo92u92k80dy2/CumulativeRankProblem.pbix?dl=0