Forum Discussion
How to ccalculate total
Hi,
Thank you for all the support.
I also need a function that will create a column named "Total after the column named "Manager" and add the total for all the categories of employees:
Thanks.
Hi Junkay
Ahmedx Good share!
You can't find column total because you're not using Matrix Visual.
And you can try to use Table Visual to create a calculated column or measure:
Create a calculated, add up the columns you need.
total = [direct contract] + [graduate trainee] + [junior] + [senior] + [manager]Create a measure, use the SUMX function for calculations.
Measure = SUMX('Table', [direct contract] + [graduate trainee] +[junior] + [senior] + [manager])Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Thanks Ahmedx. I used calculated column and it worked fine.
Thank you so much.
- Ahmedx
Super User
pls try this
I could only see the row total, no column total on the version I'm using
- Ahmedx
can you show me what your table looks like? I think it’s better for you to create a measure instead of implicit measures
pls see video
https://www.youtube.com/watch?v=f7g6EvNGClQ&ab_channel=RADACAD
https://www.youtube.com/watch?app=desktop&v=2POPWOYQjFo&ab_channel=LearnAtCloudAnalytics
Hi Junkay
Ahmedx Good share!
You can't find column total because you're not using Matrix Visual.
And you can try to use Table Visual to create a calculated column or measure:
Create a calculated, add up the columns you need.
total = [direct contract] + [graduate trainee] + [junior] + [senior] + [manager]Create a measure, use the SUMX function for calculations.
Measure = SUMX('Table', [direct contract] + [graduate trainee] +[junior] + [senior] + [manager])Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
