Forum Discussion
Ankurdatascienc
2 years agoRegular Visitor
Top N By Value not working
In attached image Page 2 I am trying to apply FIlter on the visual where I want to see Top 10 values by Turnover % but I am unable to put turnover % measure in BY value section. please help. ...
Daniel29195
Community Champion
2 years ago
deactivate the relation betwen staff and leavers,
and activate the relation between ddesignations and staff.
if you cant because you are using the relation between staff and leavers,
then just change the code of
Joinee count
measure to :
Joinee count = CALCULATE(COUNTROWS(staff),USERELATIONSHIP(dDesignations[Designation],staff[Designation]))
this also will work .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠