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 that this is not intuitive.
6 Replies
Hi Anonymous
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/Anonymous
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/
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.Hi, Anonymous ;
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 WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
