Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
101 | |
94 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
95 |