Fix DAX Matrix Totals
Budget: $30 – $250 AUD
The matrix in my Power BI dashboard shows the right values for each row, yet the grand total at the base is wrong. The model is a clean star schema: Project >Task < Calendar. The visual is configured to display a count of tasks, and several report-level filters and slicers are active, so any solution has to respect those existing interactions.
I need a refined DAX measure—or a correction to my current one—that returns an accurate total while keeping every individual row count intact. Please help me find and fix the logic so the bottom-line figure finally reconciles with the underlying data.
What you will deliver
• The corrected DAX formula (or set of formulas) pasted in a text file or shared via a PBIX snippet.
• A short note explaining why the previous total was off and how your fix resolves it.
• Confirmation that the total holds when filters and slicers are toggled.
If additional context or sample data is required, just let me know and I will provide it right away.
I need a refined DAX measure—or a correction to my current one—that returns an accurate total while keeping every individual row count intact. Please help me find and fix the logic so the bottom-line figure finally reconciles with the underlying data.
What you will deliver
• The corrected DAX formula (or set of formulas) pasted in a text file or shared via a PBIX snippet.
• A short note explaining why the previous total was off and how your fix resolves it.
• Confirmation that the total holds when filters and slicers are toggled.
If additional context or sample data is required, just let me know and I will provide it right away.
Related categories:
Data Processing
Excel
Statistics
Data Analytics
Data Visualization
Data Analysis
Power BI
Data Modeling