Summing a column... sum is on every line!

[adraus]

Why does this happen?

I want the total for a column.  In the visualizations panel, in the field, I click "sum".  This does sum the field, but it puts the total ON EVERY LINE!  I don't want it on every line, of course.

I am summing several columns on this report, but this is the only column that behaves this way.  All of the other columns look fine.  what is the deal?  How do I fix this?

[v-stephen-msft]

Hi @adraus ,

Agree with @amitchandak .

It seems that the table with column ringe$ does not have a relationship with other table with the columns in the visual.

You may create the relationships. Please kindly refer to

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

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

[amitchandak · Accepted solution]

@adraus , This is a table join issue. The table you are using is not joined with one of the tables used to group by (Don't Summarize) column