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

1 Reply

  • 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