Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add % value underneath Total Value Matrix Table

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

 

 

Need Help

3 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Allan

       

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