Forum Discussion
Total
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 t...
Hi, Anonymous ；
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.