The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.