cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
udewachter
New Member

Matrix - replace Total per row with Average

A matrix typically will list totals at collumn and row level. In order to better analyse monthly variances, I would like to compare the lastest month's numbers with the YTD monthly average. So I basically would like to see an "Average" column rather than a "Total" column as per below. The column totals in the bottom row can stay. Is this possible?

PBI.jpg

2 REPLIES 2
Highlighted
Chihiro Solution Sage
Solution Sage

Re: Matrix - replace Total per row with Average

There are many ways to do it.

 

1. Calculate measures separately for each month, and also have measure for average. Then add each into Values field in sequence. Turn off Total columns.

 

2. Use two separate visual, one for monthly values, and another for average.

 

3. Use custom visual (R-Visual to create matrix on the fly, or one from the store, that suites your need).

 

Total column isn't able to do average calculation as far as I know.

Community Support
Community Support

Re: Matrix - replace Total per row with Average

HI @udewachter,

 

Yes, it is possible. You can add if statement to check total level and write a specific formula for calculation of total level, then use condition to replace calculation on total level with that formula.


If you are confused on coding formula, please share some sample data or pbi file that we can test and coding formula on it.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors