Why can't I see the total row or summation sign in my existing dashboard table visualization

[0Experience]

Hi everyone,

I'm facing a bit of a puzzling issue with an existing dashboard I'm working on. The dashboard contains many interconnected files, and I've recently added a new dataset that isn't linked to the others. This dataset includes a text column and a numeric column.

I created a table visualization to display this data. The table correctly shows the text and corresponding numeric values, and I’ve enabled the "Total" row in the visualization settings. However, the total row doesn’t appear, and I also don’t see the summation (Σ) symbol next to the numeric field in the field list.

I’ve tried so far:

• Checked the data type of the numeric field (tried decimal, whole number, etc.)
• Verified that the “Total” option is turned on in the visualization settings

Interestingly, when I use the same dataset in a new dashboard, the total row appears as expected, and the summation sign is visible next to the field.

Has anyone encountered this before? Why would the total row and summation sign be missing in the existing dashboard but show up in a new one, even though the field data type is correct?

Any insights or suggestions would be greatly appreciated!

[parry2k · Accepted solution]

@0Experience do you have calculation groups in your model? It stops  you to use implicit measures. Add a measure, and use it in the visual.

Sum = SUM ( Table[Column] )

[parry2k]

You should accept reply as a solution that solved the issue not your own reply, although it doesn't matter @0Experience 

[0Experience]

My mistake @parry2k 

Accepted your reply

[parry2k · Accepted solution]

@0Experience do you have calculation groups in your model? It stops  you to use implicit measures. Add a measure, and use it in the visual.

Sum = SUM ( Table[Column] )

[0Experience · Accepted solution]

Thanks @parry2k 

Yes, I do have calculation groups in my dashboards.