topic Re: Table Total On Certain Columns Not Summing up correctly in DAX Commands and Tips

Table Total On Certain Columns Not Summing up correctly

Anonymous — Sun, 08 May 2022 22:28:10 GMT

I have a measure Languages Board = IF([Short Languages]<>0,1,0) on a table visualization but the grand total is not showing correct. I am expecting it to Total it just like the other columns not 1, see screen shot.

Re: Table Total On Certain Columns Not Summing up correctly

VahidDM — Sun, 08 May 2022 23:01:48 GMT

Hi Anonymous

That's a total issue because you used IF statement in your formula, it's very common.

Please check this link and you will find how to handle this situation:

https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Table Total On Certain Columns Not Summing up correctly

Anonymous — Wed, 11 May 2022 02:51:52 GMT

Hi Anonymous

Mesaure is different from calculated column. When it is added to visual, the fields in Values have no aggregate calculation. So it returns a different value than regular column and calculated column. If you need its last value to be total, I suggest you can create calculated column.

In this case , you can created a calculated column like this :

Column = SWITCH(TRUE(),'Table'[Short Languages]<>0,1,0)

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.