How to toggle between % and absolute values in a matrix

[RogerSteinberg]

Hi everyone,

Simply put I would like to toggle between my absolute values in a table/matrix to % as a column or row or grand total.

How can I achieve this ?

Thank you

[v-cherch-msft · Accepted solution]

Hi @RogerSteinberg 

You may create a slicer table like below.Then create a measure to get the value.

Value_New =
IF (
    ISFILTERED ( Slicer[Type] ),
    SUM ( 'Table'[Value] )
        / CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[date] ) ),
    SUM ( 'Table'[Value] )
)

Regards,

Cherie