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.
The total in the matrix is not showing the correct value, however when exported in excel it shows the correct value.
So in the image you can see the value against the person is shown as 5275 but the total shows 6575. Any idea why is this so?
Solved! Go to Solution.
Hi @rveerasamy ,
Please try to create a new measure as below, then drag the new created measure onto Matrix to replace the measure Sales Amount:
Measure =
SUMX (
VALUES ( 'SALES'[PARENT ACC NAME] ),
SUMX ( VALUES ( 'SALES'[FULL NAME] ), [Sales Amount ] )
)
If the above method is not working, please provide some sample data which is from the applied fields on Matrix and the table structures in your data model if the matrix involves multiple tables data. Thank you.
Best Regards
Rena
Hi @Avivek ,
Whether the field "Sales Amount" is from the returned values of a measure? You can refer the contents in following links to update the formula of your measure to get a correct total value.
Wrong Grand Totals in Power BI
In addition, you can also provide some sample data which is from the applied fields on Matrix and the formula of measure "Sales Amount", later we will help you correct it. Thank you.
Best Regards
Rena
@Avivek , can you share the formula.
Hi @rveerasamy ,
Please try to create a new measure as below, then drag the new created measure onto Matrix to replace the measure Sales Amount:
Measure =
SUMX (
VALUES ( 'SALES'[PARENT ACC NAME] ),
SUMX ( VALUES ( 'SALES'[FULL NAME] ), [Sales Amount ] )
)
If the above method is not working, please provide some sample data which is from the applied fields on Matrix and the table structures in your data model if the matrix involves multiple tables data. Thank you.
Best Regards
Rena
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |