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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Bebs
Helper II
Helper II

Is it possible to customize a total in Matrix table to avoid measures creation ?

Hello,

my customer wants to have a matrix table on budget with that kind of columns :

Quarter 2, Quarter 3, Quarter 4, Total Quarter 2 => Quarter 4, for each line % of the total

I'd like to avoid to create a measure for each column, is there a way to avoid that ? (The number of quarter will depend of the version of the budget).

 

 

If I use a quarter field as a column of the table, I've most of it  :  I will simply and dynamically have a value for each quarter , then the total of the columns will be the total of all quarter.  I just need additional column to add the % of each line of the total ; is there a way to get it ?

 

A idea may be to add one more total column by adding a field in column (exemple : year) with just one value for all the table : in that way I get another total ; then is there a way to change the calculation of the total to create the % of each line calculation ?

 

Best regards

 

 

1 REPLY 1
amitchandak
Super User
Super User

@Bebs , Not very clear. But isinscope should help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

 

or calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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