Incorrect Sum of Column

[Anonymous]

Hello, I am hoping you can help me with this. I was building a dashboard for a client and I want to sum the 

*unplanned Total Exceptions OPS column. the sum should be 568 but when I use measure for sum and I applied it on a card visual, the result is 13. can someone please give me an idea why is this happening? Thank you in advance!

            

[Anonymous]

Hi @Anonymous ,

What's your measure?

Try

CALCULATE(SUM('Table' [unplanned Total Exceptions OPS], ALL('Table')))

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.

[tamerj1]

Hi @Anonymous 

it is obvious that there is a filter coming from somewhere that is filtering only the row that contains the value 13. Check other visuals, slicers and the filter panel. Also make sure that the code is just a simple SUM with no filters or conditions 

[Anonymous]

Hi @Anonymous ,

If you just want to display the sum of the column in a Card, just drag the column into the field. Did it not work? Or there are other slicers or filters filtering the data?

[Anonymous]

You can also hover on the funnel on the top right of the Card to see if there is any filter affecting the visual