cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
elenita62 Frequent Visitor
Frequent Visitor

Max of count filter only by UserName

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.

 

 

3 REPLIES 3
Super User
Super User

Re: Max of count filter only by UserName

@elenita62

 

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

 

editinteractions.png

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




elenita62 Frequent Visitor
Frequent Visitor

Re: Max of count filter only by UserName

It does not apply to my case...

 

Any way thank you for your help

Moderator v-yuezhe-msft
Moderator

Re: Max of count filter only by UserName

Hi @elenita62,

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


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.