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
Hi All,
I have an excel file with 3 columns: "Month", "Name" and "Quantity" as you can see below.
I've created a first measure to have the max value for each customer by month:
Max by customer = CALCULATE(MAX(Feuil1[Quantity]))
Below is the result for the month "11":
That's great, but when I went a level up and displayed the values by month, I got the result below:
For the month 11 I got the maximun value 250.00 but what I need is to the the SUM of each max value for each customer, which will be : 250.00 + 172.40 + 120.80 + 110.20 + 78.10 + 25.60 = 757.10
How I can fix fix it ? and modify my measure to get the SUM of the maxinum values for each month ?
Below is how I diplay my data:
Thanks in advance 🙂
Solved! Go to Solution.
Give this a try.
Sum Max = SUMX ( VALUES ( YourTable[Name] ), [Max by customer] )
You will have to change the measure to match your table name.
Give this a try.
Sum Max = SUMX ( VALUES ( YourTable[Name] ), [Max by customer] )
You will have to change the measure to match your table name.
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 |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |