Forum Discussion
Solved
Matrix total help please.
Hi, Power Bi newby here. I have the following matrix of data. Can anyone explain why the column totals on the side are correct but the row totals at the bottom dont sum correctly. The values in ...
You chose to show a distinct count. One CM value is present in multiple Types.
Oh thanks you! This has been bothering me for hours and I couldnt work it out. Now you have pointed it out it is so simple. This "shouldn't" happen because the type shouldnt change between rows of data with the same invoice number (the discount count) but clearly somehow it has been adjusted. Now I have found the issue (both occurances) and can fix it.
Thanks again.