Forum Discussion

RogerSteinberg's avatar
RogerSteinberg
Post Patron
7 years ago
Solved

How to toggle between % and absolute values in a matrix

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
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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