Forum Discussion

Amos_Lim's avatar
Amos_Lim
Icon for Resolver I rankResolver I
1 year ago

DAX Synex EARLIER Error

Hi,   My code keeps showing EARLIER/EARLIEST refers to an earlier row context which doesn't exist.. Any help would appreciate. Thanks.   Rank = RANKX(FILTER('ForkLiftData', 'ForkLiftData'[SAP N...
Need Help
Show and Tell
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Hi Amos_Lim ,

Whats is the criteria for rank? what will determine to forklift stand in first position or last? please give more details to help you

Amos_Lim's avatar
Amos_Lim
Icon for Resolver I rankResolver I
1 year ago

I am trying to use DAX to rank the forklifts for each user.

 

 

and use DAX to display user details only for the first row of each user. Repeat the same DAX for other column except ForkLift Name

 

In summary:-

My intension was to make the table in the PBI dashboard that listed all users and the forklifts they are authorized to drive.

 

and currently, the table displays multiple rows of the same user, with their 'User Name', 'SAP Number', 'Forklift Name', 'POC', 'Department', and 'License Valid Until' if the user has access to different forklifts.


So for repeated user, I would like to just display their information in the 1st row, and for the 2nd or 3rd or more with the same user will just shows the different ForkLift and the rest of the columns show "Blank"?