Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |