Forum Discussion

AuroraNI's avatar
AuroraNI
Helper III
5 years ago
Solved

difference based on dynamic rank

Hi, I have the below table in PBI and I would like another column in this table that calculates the time differences between 1st place and all the other runners, and this would change based on the e...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    AuroraNI 

     

    Thanks for the file. It made things easier.

    This works:

     

AuroraNI's avatar
AuroraNI
Helper III
5 years ago

Thank you PaulDBrown 

I have tried and it seems to be working on the first row but not on the rest

 

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

@AuroraNI

Sorry, you need to use the "name" field in the ALLSELECTED (no the "event" field)

Also, if you are using a field from a dimension Table, you need to use the field in the ALLSELECTED from the corresponding field.

In the following example I'm ranking by sales and calculating the difference vs the smallest sales number.

The field used in the rank measure, the visual, and the [Dif vs rank 1] all come from the Dim Item table (dimension table; not the fact table) The field you use must be consistent throughout. (so either your name field is from the fact table or from the dimension table)

Dif Rank.JPG