cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bharathsurya
Helper I
Helper I

Not able to get desired output on matrix

My data is in the format given below.

bharathsurya_0-1626950053633.png

Required output is shown below

 

bharathsurya_1-1626950190146.png

 Column B represents total number of accounts in that month. 
I'm not able to get the total in column B.

Thanx in advance.

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @bharathsurya,

You can create a new table with all column values and add custom value 0, then you can use this new field on the column field and write a measure expression with if statement to summary values and replace the result if the current column value is equal to 0.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @bharathsurya,

You can create a new table with all column values and add custom value 0, then you can use this new field on the column field and write a measure expression with if statement to summary values and replace the result if the current column value is equal to 0.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

amitchandak
Super User IV
Super User IV

@bharathsurya , You can enable column total in matrix. But I doubt you can move that to first place.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors