Forum Discussion

Raveein26's avatar
Raveein26
Regular Visitor
2 years ago

Getting wrong row subtotals in matrix table.

In our Power BI report, we have a calculated column (Column C) defined as follows: Column C = Column A / Column B. The requirement is to get the subtotals for Column C as the sum of individual rows o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Raveein26 ,

 

Generally, the calculated columns do not have subtotal errors in the matrix, this generally occurs in measure, can you share sample data and sample output in tabular format? Or sample pbix after removing sensitive data. We can understand the issue better and help you.

You can also try the following dax:

MeasureC_if=
var _table1=
SUMMARIZE('Table','Table'[Group],"Value",[MeasureC])
return
IF(
    HASONEVALUE('Table'[Group]),[MeasureC],SUMX(_table1,[Value]))

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Raveein26's avatar
Raveein26
Regular Visitor
2 years ago

Hi Anonymous 

You can see your matrix visual for Measure C column you are getting a wrong total. It should be 5.50  but you are getting 5.00.


Same issue I am facing in my matrix. Please find the below screenshot. For C column I am getting total as 17.22 but It should be  23.61.