Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Total row in matrix is incorrect

I am working with the below calculated measure that is being used for the values of a matrix in Power BI. The totals associated with this matrix are incorrect and I could use some insight as to how b...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

Here you go

 

However I don't see how did you get the 7557 count!

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

aj1973 Let me rephrase my 7,557 count. If I manually (calculator or Excel) add up all the rows, I get 7,557, not 7,519. This is the issue. The total should equal the total.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Not sure how you are calculating in excel. COUNTA doesn't count the number of rows in the table. If you want to see 7557 then use COUNTROWS INSTEAD.