Forum Discussion
Sum level: how to fix it?
At the beginning, I have the following table:
----------------------------------------------------------------------------------
City Server Count Num1 Num2
-------------------------------------------------------------
Ottawa A 1 1 0
Ottawa A 1 0 1
Ottawa A 1 1 1
Ottawa A 1 0 0
Ottawa B 1 1 1
Ottawa B 1 0 0
Toronto C 1 0 1
Toronto D 1 1 0
--------------------------------------------------------------
Use matrix in power bi, I can see the following table
------------------------------------------------------------
City Server Sum of Count Sum of Num1 Sum of Num2
---------------------------------------------------------------------------------
Ottawa A 4 2 2
Ottawa B 2 1 1
Toronto C 1 0 1
Toronto D 1 1 0
__________________________________________________________________________
Total 8 4 4
But right now I have:
City Server Sum of Count Sum of Num1 Sum of Num2
---------------------------------------------------------------------------------
Ottawa A 8 4 4
Ottawa B 8 4 4
Toronto C 8 4 4
Toronto D 8 4 4
--------------------------------------------------------------------------
How to fix it?
Anonymous So, I still think there might be a relationship issue then between 2 tables since the numbers are the same for each row. But, to answer your question, look in the Visualizations pane. Find the "Orders" column in one of th field wells. Should be in Values I imagine. Over on the right is a little V icon and an X icon. Click the V icon and choose "Do not summarize".
4 Replies
- Greg_Deckler
Community Champion
Anonymous This can often be the result of a missing relationship between 2 tables. When you say you can see the following table in a matrix do you mean that's what you want to see or that you actually see that?
- Greg_Deckler
Anonymous So, I still think there might be a relationship issue then between 2 tables since the numbers are the same for each row. But, to answer your question, look in the Visualizations pane. Find the "Orders" column in one of th field wells. Should be in Values I imagine. Over on the right is a little V icon and an X icon. Click the V icon and choose "Do not summarize".