Total

[jellis1971]

I have created a simple table visualization.  But, even though "Total" is turned on in the Formatting, a total is not appearing for all columns.

Why not, and how do I get a total?

I can't believe that this is not intuitive.

[v-yalanwu-msft]

Hi, @jellis1971 ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @jellis1971 ；

Because the aggregation is done for each column. Simply say you have 5 columns, select count as the aggregate type, then each column has the corresponding count sum;
If you want to get the total count of five columns, you can use measure to do it and put it in the card. For example：

1.orginal count by every column.

2.create a measure.

Measure = DISTINCTCOUNT([Column1])+DISTINCTCOUNT([Column2])+DISTINCTCOUNT([Column3])+DISTINCTCOUNT([Column4])+DISTINCTCOUNT([Column5])

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @jellis1971 

It depends on the column data type and aggregation.

check the data types of your columns.

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/

[jellis1971]

They're Whole Numbers.  So, they should simply add across.  They don't.

[VahidDM]

@jellis1971 

Did you check the column aggregation?

https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates

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/

[jellis1971]

Each column is of a "count" aggregation. 

There are five columns. 

So, if the value of each column respectively is 3, 5, 2, 8, and 9, then I would like to see a separate total of 27.