Forum Discussion
Percentages calculation
Hi All, I have created a matrix as you can see below. The total of column 'Values' based on selected filters is 4,2M (year 2019 and 2020 are not selected). I would like to create a new colum...
Hi, Anonymous
You can try the following methods.
Total = CALCULATE(SUM('Table'[Values]),ALLSELECTED('Table'))The Total value is also updated as the slicer changes.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
create a new column like below
total = sum(values)
it will show the total