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

[Bebs]

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

[amitchandak]

@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