Forum Discussion
Matrix Totals
I have never used a matrix and I need to use one for an upcoming project
The totals are throwing me off though, why is it summing 'Average Hourly Rate - Actuals' and 'Total Salaries - Actuals'?
sorry to bug you again edhans
4 Replies
Anonymous - This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Hi, Anonymous
It depends on how the meausres 'Average Hourly Rate - Actuals' and 'Total Salaries - Actuals' are calculated. The value of a calculated column is computed during data refresh and uses the current rowas a context; it does not depend on user activity on the pivot table. A measure operates on aggregations of data defined by the current context. Could you please show us your measure and the expected result? Do mask sensitive data before uploading. Thanks.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is my link to the file, I am expexting all the total rows to equal the row above them (like the first 3 columns do)
https://www.dropbox.com/s/gp3oz1dpot4zwi4/IS%20Salaries%20Mock%20up%20Test.pbix?dl=0
