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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
JamieH
Helper I
Helper I

Measure to calculate column % per row in a matrix

I have a matrix that has the following attributes:

Rows

   BookingMonth

   AccStatus

Columns

   MonthsSinceBooking

Values

   Balance

 

So essentially, for each booking month, I can see the different AccStatus for each month since booking.  This all works fine when just showing the balance.  

What I would also like to see though, is the percent for each AccStatus in the BookingMonth by each MonthSinceBooking.

 

As an example, this is a made up view of what the matrix looks like now:

 

BookingMonth123
July 2022100100100
  Status A908070
  Status B101018
  Status C01012
August 2022250250 
  Status B150175 
  Status D10075 

 

This is what I would like it to show:

 

BookingMonth123
July 2022100%100%100%
  Status A90%80%70%
  Status B10%10%18%
  Status C0%10%12%
August 2022100%100% 
  Status B60%70% 
  Status D40%30% 

 

Can someone please advise on how to create a measure that would show this please?

 

Thanks

5 REPLIES 5
Anonymous
Not applicable

Hi @JamieH ,

 

You can directly through this option to change the data value to percentage mode.

vmengzhumsft_0-1668671383450.png

 

Best regards,

Community Support Team Selina zhu

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

 

 

Hi there, 

 

Yes, this doesnt work though.  Because I have 2 variables in my Rows element (BookingMonth and AccStatus), none of the percentage options breakdown each bookingMonth into 100% intervals.   It does it for the whole matrix 

JamieH
Helper I
Helper I

And no, BookingMonth comes on the one table with all the other data that makes up this matrix.  So no Date Table.

JamieH
Helper I
Helper I

Thanks Amit. 

 

No, no measure used for M1/M2 etc.  The data comes in with a row for each Month.

amitchandak
Super User
Super User

@JamieH , Assume you have a measure M1 used in matrix

 

then you can try  a measure like

divide([M1], calculate([M1], removefilters(Table[Status])) )

 

if you are using date table for the month year

 

divide([M1], calculate([M1], datemtd(endofmonth(Date[Date])))  )

 

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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