Calculate Variance on Measures in Matrix table

[ressul]

Hi all,

I have a matrix table Ilike below:

                          Company 1                 Company2

                      2021        2022            2021         2022

MEASURE1      x%          x%                x%             x%

MEASURE2      x%         x%                 x%            x%

MEASURE3      x%         x%                x%             x%

And I wish to add a variance column so the table will become like:

                               Company 1                                         Company2

                      2021        2022        YoY Var               2021         2022          YoY Var

MEASURE1      x%          x%             y%                     x%             x%               y%

MEASURE2      x%         x%              y%                     x%            x%                y%

MEASURE3      x%         x%              y%                     x%             x%               y%

Is this possible? I know a Measure can not be shown in Column so can't think of any way to create this variance column.

I'm thinking to convert these measures into a column (i.e. each measure becomes a row of this column), not sure if it's possible via DAX?

Thank you in advance!

[v-rongtiep-msft]

Hi @ressul ,

Could you please provide the formulas about measures so that I can convert it to column form for you.

If it is possible, please provide your pbix file without privacy inforamtion and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Whitewater100]

Hi:

They have changed some  formatting options. If you go to "Values" you can accomplish mesures on row. Please see image. Thanks..

[tamerj1]

Hi @ressul 

you can use the columns subtotal to disply this value by editing the code of the same measures 

[ressul]

Thanks @tamerj1 . Are you able to show how exactly this can be done?