- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
I have another idea, If if get rid of including in the view below "Rank" field:
> Rank =RANK(
DENSE,
ALLSELECTED(act_source[Signature team ID],act_source[Signature Team Name],act_source[Distance],act_source[Divisions],act_source[FA count],act_source[Average Production Category],act_source[FA Name], act_source[Average AuM], act_source[Average NYSE LoS],act_source[Submitted_Bio_Team],act_source[fa_demo],act_source[Average AuM Category],act_source[Average UBS LoS]),
ORDERBY([Model score weighted], desc,act_source[Signature team ID], ASC, act_source[Signature Team Name], desc)))
and replace it only by below measure, but sorted in the view descending, can I somehow get "LLR Status" slicer working as expected? Currently when I try to include below measure in the view, the view is not reacting on "LLR Status" slicer selections.
> Model score weighted = [Productivity table teams Value] / 100 * AVERAGE(act_source[team_prod_model_score]) + (100 - [Productivity table teams Value])/100 * AVERAGE(act_source[fa_prod_model_score])"