Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ressul
Regular Visitor

Calculate Variance on Measures in Matrix table

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!

 

4 REPLIES 4
Anonymous
Not applicable

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
Solution Sage
Solution Sage

Hi:

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

Whitewater100_0-1653221808278.png

 

tamerj1
Super User
Super User

Hi @ressul 

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.