Hello all,
I am trying to create a matrix table in PowerBI to display the information on my normal table that I have created. When I create the matrix table however, it summs data that I do not want summed. (I have changed the data to "Do not summerize" before I even dragged the data into the matrix table.
The example in the picture provided shows both the table I created (On the left) and the matrix table (On the right).
If you take a look at the date of Jan 10, 2018; You will see on the table there are two different entries, two seperate totals, and two seperate tonnages. On the matrix table however, it has grouped these into one line and summed the total for that specific day. This is not what I want, I want the data to sum at the end for all of the data in the table. When it sums it by day like it has, it screws the numbers that I am looking for and is incorrect matched to my master excel file that demonstrates what each final total should be.
If anyone can help me out with this, it would be greatly appreciated! I am new to PowerBI.
