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.
hi, one way is disable the interaction between slicer and table visual with your Max info.
It does not apply to my case...
Any way thank you for your help
Hi @elenita62,
Could you please post the whole sample data of your tables so that we can test it?
Thanks,
Lydia Zhang
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
105 | |
77 | |
72 | |
48 | |
47 |
User | Count |
---|---|
158 | |
86 | |
80 | |
68 | |
66 |