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.
Qty Jan - 15
Qty Feb - 10
Qty Mar - 22
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.
MaxTicketHistorico = CALCULATE(
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.
Proud to be a Datanaut!
Could you please post the whole sample data of your tables so that we can test it?