Add % value underneath Total Value Matrix Table

[Anonymous]

Hi Expert

See image of sample data, i have a Total Sum measure for Value column which gives me the correct values for each product by Year  as shown below, how can i add a % value as also shown in the orange highlight. in a matrix table PBI

[v-alq-msft]

Hi, @Anonymous 

I don't think it is possible to add a % value as also shown in the orange highlight. As a workaround, you may create a measure as below. The pbix file is attached in the end.

Result = 
IF(
    ISINSCOPE('Table'[Product])&&NOT(ISINSCOPE('Table'[Period]))&&NOT(ISINSCOPE('Table'[Year])),
    var a = LOOKUPVALUE('Table'[Value],'Table'[Product],MAX('Table'[Product]),
    'Table'[Year],MAX('Table'[Year]))
    var b = LOOKUPVALUE('Table'[Value],'Table'[Product],MAX('Table'[Product]),
    'Table'[Year],MIN('Table'[Year]))
    return
    DIVIDE(b-a,a)
)

Result:

Best Regards

Allan

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

[Anonymous]

Hi Allan

Thanks firstly for the excellent feedback do you have a pbix file you could share? Re solution 

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

The pbix file is attached in the end of the reply.

Best Regards

Allan

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