topic Re: Incorrect Sum of Column in DAX Commands and Tips

Incorrect Sum of Column

Anonymous — Fri, 04 Mar 2022 04:31:03 GMT

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!

Re: Incorrect Sum of Column

Anonymous — Fri, 04 Mar 2022 05:34:12 GMT

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?

Re: Incorrect Sum of Column

Anonymous — Fri, 04 Mar 2022 05:57:14 GMT

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

Re: Incorrect Sum of Column

tamerj1 — Fri, 04 Mar 2022 06:09:11 GMT

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

Re: Incorrect Sum of Column

Anonymous — Tue, 08 Mar 2022 07:56:22 GMT

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.