Max of count filter only by UserName

[elenita62]

Hello,

I have a list of Users Names and all that I need is to obtain the max count value of all time for each one. 

Example:

UserName> Elopez 

Qty Jan - 15

Qty Feb - 10

Qty Mar - 22

UserName> TMontilla 

Qty Jan - 25

Qty Feb - 30

Qty Mar - 20

I need to obtain 

Elopez max qty        22

TMontilla max qty   30

And  I dont care if the month is filtered or not.

The Qty is a Count distinct measure.

My expression:

MaxTicketHistorico = CALCULATE(
DISTINCTCOUNT(TicketsPorUsuarios[TicketID]), ALLSELECTED(TicketsPorUsuarios[MesInicio]))

But when I filter by date the MaxTicketHistorico shows filtered values.

[Vvelarde]

@elenita62

hi, one way is disable the interaction between slicer and table visual with your Max info.

[elenita62]

It does not apply to my case...

Any way thank you for your help

[Anonymous]

Hi @elenita62,

Could you please post the whole sample data of your tables so that we can test it?

Thanks,
Lydia Zhang