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.
I have a matrix that is made of data that is coming from 2 servers. The "values" field is set to "maximum" so I can see what the largest value is from the data set based on year, quarter, month, and day. I want the total to show the sum of the 2 maximum values instead it reporting the highest of the 2 values as a total.
Solved! Go to Solution.
You should make a measure instead of using the implicit measures created by dragging a column into the field well. Here is one that should work.
NewMeasure = SUMX(VALUES(Table[Server]), CALCULATE(MAX(Table[Column])))
Replace Table with your actual table name (the same column used in your visual), and replace column with the column used in your max calculation.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You should make a measure instead of using the implicit measures created by dragging a column into the field well. Here is one that should work.
NewMeasure = SUMX(VALUES(Table[Server]), CALCULATE(MAX(Table[Column])))
Replace Table with your actual table name (the same column used in your visual), and replace column with the column used in your max calculation.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank You!
Here is an example of someone else that did it but not understanding how they arrived to the solution. https://community.powerbi.com/t5/Desktop/Set-values-as-Maximum-but-want-to-have-the-grand-total-sum-...
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |