Show name of who has most cases

[Anonymous]

Hi eveyone,

I'm trying to dynamically show in a card visualisation which team member has the most cases due today.

So for today I want to show "Zoe".  The TotalCasesDueToday is a measure...

TotalCasesDueToday = CALCULATE(
SUM('Cases'[TotalActiveCases]),
FILTER('Cases',[resolveby]=Today())
)

I hope this is enough detail to go off..?

Many thanks for any help you can give.

xXx

[Vvelarde]

@Anonymous

Hi!!, you can obtain this using this dax in a measure

NameTop =
CONCATENATEX (
    TOPN ( 1, 'Cases', [TotalCasesDueToday], DESC ),
    'Cases'[Name],
    "."
)

ConcatenateX will help you when have 2 or more names in TOP1.

[Anonymous]

Thanks for replying so quickly!

This isn't quite right as it shows a list of everyone concatenated together, by overall total and not the total for today.

[Vvelarde]

@Anonymous

Please share sample data to adjust my answer to this.

[Anonymous · Accepted solution]

I have solved this using RANKX

MostCasesDueTodayName = RANKX(ALL('Cases'[owneridname]),CALCULATE(SUM('Cases'[TotalActiveCases]),'Cases'[resolveby]=TODAY()))

I substituted the measure for the original column and filter instead of the measure I'd built to show that.

I then used a multi row card and put a filter on to show where MostCasesDueTodayName = 1