cancel
Showing results for
Did you mean:
Regular Visitor

getting a column value based on the score

hi ,

i have matrix below  where each case owner has score based on the total number of case

i would like to get the case owner who has max score for the current month and last month , to find score am using

score = (CALCULATE(DIVIDE([Cases Resolved Within TAT] , [Total Case])))

i have current month total case and current month resolved case within tat , now i need the user name to be displayed in a card who has the max score
1 ACCEPTED SOLUTION
Super User IV

@jaleef , sorry small modification

top OWNER THIS MONTH = CALCULATE(max(incidents[owninguser.fullname]),TOPN(1,allselected(incidents[owninguser.fullname]),[current month score],DESC),VALUES(incidents[owninguser.fullname]))

Proud to be a Super User!

3 REPLIES 3
Super User IV

@jaleef , Try measures like

top OWNER THIS MONTH = CALCULATE([score],TOPN(1,allselected(Table[case owner]),[score],DESC),VALUES(Table[case owner]))

top OWNER lAST MONTH CALCULATE([score LMTD],TOPN(1,allselected(Table[case owner]),[score LMTD],DESC),VALUES(Table[case owner]))

Use date table and time intelligence for last two measure

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Proud to be a Super User!

Regular Visitor

hi, its giving me some value not i expected

i used

current month score = DIVIDE([Current month resolved case], [Current month Total case]) then
i used
top OWNER THIS MONTH = CALCULATE([current month score],TOPN(1,allselected(incidents[owninguser.fullname]),[current month score],DESC),VALUES(incidents[owninguser.fullname]))

its giving me some number , i actually need top scorer owning user column value
Super User IV

@jaleef , sorry small modification

top OWNER THIS MONTH = CALCULATE(max(incidents[owninguser.fullname]),TOPN(1,allselected(incidents[owninguser.fullname]),[current month score],DESC),VALUES(incidents[owninguser.fullname]))

Proud to be a Super User!

Announcements

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors