Calculating days since hitting a speed within sport data set

[jordanwhite16]

Hi all,

I have a measure MaxSpeed90 already calculating 90% of a players max speed ever achieved, and I am collecting a max speed for the training sessions for individuals on a daily basis in a 'MaxSpeed' column. I am trying to calculate how many days it has been since that MaxSpeed90 number has been hit within the training data set of my 'maxspeed' column, but am struggling to get the end format into days whilst also figuring out the DAX to get to that end result. Any help would be greatly appreciated.

Thanks

[Anonymous · Accepted solution]

Hi @jordanwhite16 ,

Due to I don't know your data model, I create a sample to have a test.

Max Speed = CALCULATE(MAX('Table'[Speed]),ALLEXCEPT('Table','Table'[Player]))

Count Days after Max Speed = 
VAR _MAXSPEEDDAY = CALCULATE(MAX('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Player]),'Table'[Speed] = [Max Speed]))
RETURN
CALCULATE(COUNT('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Player]),'Table'[Date]>_MAXSPEEDDAY))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.