Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |