Matrix visual error

[ramhariessentia]

Hi all I am getting sum error in Matrix visual, what might be the reason.

Sum of total Projects on the extreme right is correct, but the total of the column are wrong.

[v-robertq-msft · Accepted solution]

Hi, @ramhariessentia 

According to your sample picture, it seems that you faced with the problem of the total row of a measure calculation error, you can try to create a new measure like this:

SumDistinctCount_new =

var _new=SUMMARIZE('Table','Table'[Fee Name],"_value",[Measure])

return IF(HASONEVALUE('Table'[Fee Name]),[ Measure],SUMX(_new,[_value]))

Then you can go to replace the original measure within your matrix.

And you can check if you can get the total to display what you want.

For more info about the trick, you can check these link:

Dealing with Measure Totals - Microsoft Power BI Community

Solved: How to show total row as sum of distinct count? - Microsoft Power BI Community

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[ramhariessentia]

Thanks, it works, however, i may have miscommunicated the requirement, How to ensure the subtotal level is same as full total level

[amitchandak]

@ramhariessentia , if this count is distinctcount , then power bi recalculate distinct count again at sub total and total level so it may differ

You can try a measure

sumx(summarize(Table, Table[Fee Name], Tbale[Batch Date].Year, "_1", distinctcount(Table[Project Id])),[_1])