Percentages calculation

[Anonymous]

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 column in this matrix which will show in every row the total of column 'Values' ( 4,2M ).

Do you know how to solve that problem? 

Thanks!

[v-zhangti · Accepted solution]

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.

[Arul]

@Anonymous ,

you can try,

Measure name = calculate(measure/column,ALLSELECTED(year)) 
or
Measure name = calculate(measure/column,ALLSELECTED())

Thanks,

[negi007]

@Anonymous 

create a new column like below

total = sum(values)

it will show the total