I'm a french newbie with PowerBi.
I'm a bit lost with rankx. Here is my problem
For each car number I want to calculate these two columns:
- Lap time ranking
- stint number : each stint ranking (a stint is each time the car go on track, separated per a box entry "B")
here is an example with 2 cars
|car N°||lap time||Box||lap time ranking||stint number|
Based on my test, you could refer to below formula to calculate the rank:
Rank = RANKX('Table1','Table1'[lap time],,ASC,Dense)
But I could not figure out the logic of how to calculate the stint number, could you please offe me more information about it?
thanks for your help.
Because my database is with a lot of data I have this error message :
A single value for column ' Lap Time' in table 'Table 1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
The stint calculation is just
1st stint is from 1st lap time until B in box column
2d stint is after the 1st B (Box) you find until the 2d B you find or until next car
I hope it's clear now.