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.
Hi,
I'm experimenting with PowerBI, which is a fantastic tool and have a great community.
I have a table of deals per customer. We are selling our products as license per user, therefore a customer might add or reduce the number of licenses during its global subscription.
I've created a cumulative total measure and i want now to be able to determine for each customer what was its highest subscription since it's a customer.
For instance, all the deals in the large red rectangle relate to one customer. The highest value is in the small red rectangle.
I'm stuck because the running total is a measure, and the MAX function requires a column.
Can you help me on this one?
Thanks in advance
Hi @Pepperi,
Please refer to below measures:
Rank = RANKX ( ALLEXCEPT ( 'Test Table', 'Test Table'[Custom] ), [OPP MRR USD running total], , DESC, DENSE ) Max running total = CALCULATE ( [OPP MRR USD running total], FILTER ( ALLEXCEPT ( 'Test Table', 'Test Table'[Custom] ), [Rank] = 1 ) )
Best regards,
Yuliana Gu
Hi Yuliana, thank you very much for your reply.
In your example, assuming the deals are sorted by date, I don't understand the cumulative total.
The figures should be:
Anyway, i tried your solution but the results are not as expected:
Hi @Pepperi,
In your scenario, how did you calculate the Running Total values? Also, are records sorted by date in your scenario?
Regards,
Yuliana Gu
Can you share the DAX for this problem? I'm running into the same issue
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |