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.
In excel there is the ability to sum columns but average by row. How do I achieve this in a Matrix?
You create a measure and use HASONEVALUE() to figure out where in the matrix you are (cell, row total, column total, or grand total) and calculate the measure accordingly.
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 |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |