So the problem here is that you don't have a RANK entry against any of the users. The LoD is creating a SUM of Target for each Event/Rank combination.
If you remove RANK from the LoD expression it should work.
Hi @simon Runc, Thanks for your reply.
Unfortunatly it didn't fixed the issue by removing [Rank] in the fixed formula.
When the filter [user] is applied (for instance on User 01), it's then showing the correct objective but wtihtout the [rank] field I am interested to show.
I have to say I am not sure how to handle this one.
I really hope you can help me
I attach the tableau dashboard file.
So without having Rank in any of the User Rows, means that when you filter on a single user there is no longer a row per Rank (even if you use an LoD).
One solution, is that the "null" User (which forms the Target/Rank rows is always left ticked). Another way is to use a Blend. In the attached I've brought in the data twice, and then built the Viz (the Target from one file and the User Icons from the other). I then use 'Event - Group' as the Blend field (this is important as if we use Rank and Event we get a similar issue as before)
Now when we select a User only the Icon's change.