Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 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!

 

 

Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

3 Replies

  • negi007's avatar
    negi007
    Community Champion
    3 years ago

    Anonymous 

     

    create a new column like below

    total = sum(values)

     

    it will show the total

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Anonymous ,

    you can try,

     

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

     

    Thanks,

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    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.