Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table Total On Certain Columns Not Summing up correctly

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, s...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.