Forum Discussion
Totals not summing up correctly within matrix
Hi GD1988 ,
Thanks for reaching out to the Microsoft fabric community forum.
You can start by checking a couple of common causes for incorrect totals in Power BI matrices:
Recheck your data model relationships, Ensure that the relationships between your fact and dimension tables are correctly defined. An incorrect or missing relationship can cause the same value to repeat across multiple rows or months.
Remove or review any unintended filters or context, Sometimes totals appear inflated because of filters applied at the visual or measure level. Review your DAX measure and the matrix filters to confirm that no implicit filter (such as an inactive relationship or ALL modifier) is affecting the calculation. If needed, create an explicit measure using functions like CALCULATE, SUM, or SUMX to correctly aggregate values by branch and month.
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi GD1988 ,
Thanks for reaching out to the Microsoft fabric community forum.
You can start by checking a couple of common causes for incorrect totals in Power BI matrices:
Recheck your data model relationships, Ensure that the relationships between your fact and dimension tables are correctly defined. An incorrect or missing relationship can cause the same value to repeat across multiple rows or months.
Remove or review any unintended filters or context, Sometimes totals appear inflated because of filters applied at the visual or measure level. Review your DAX measure and the matrix filters to confirm that no implicit filter (such as an inactive relationship or ALL modifier) is affecting the calculation. If needed, create an explicit measure using functions like CALCULATE, SUM, or SUMX to correctly aggregate values by branch and month.
I hope this information helps. Please do let us know if you have any further queries.
Thank you