Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Percent Change Between Matrix

I have this matrix that I would like to add a third column with the percent change between the two categories. For instance, the first value for U-16191 would be about a -17.99% decrease. How do I ac...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Anonymous 

    Try steps as below:

    Create measure "measure value" to instead  the field  "value" :

    Measure  value =
VAR _inital_Request =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[Category] = "Initial Request" )
    )
VAR _MPSC_Approved =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[Category] = "MPSC Approved" )
    )
RETURN
    IF (
        ISINSCOPE ( 'Table'[Category] ),
        SUM ( 'Table'[Value] ),
        _MPSC_Approved / _inital_Request - 1
    )

      

    Change the column subtotals label from total to"Percentchange"

     

    Here is a demo .

    pbix attach 

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

Try steps as below:

Create measure "measure value" to instead  the field  "value" :

Measure  value =
VAR _inital_Request =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[Category] = "Initial Request" )
    )
VAR _MPSC_Approved =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[Category] = "MPSC Approved" )
    )
RETURN
    IF (
        ISINSCOPE ( 'Table'[Category] ),
        SUM ( 'Table'[Value] ),
        _MPSC_Approved / _inital_Request - 1
    )

  

Change the column subtotals label from total to"Percentchange"

 

Here is a demo .

pbix attach 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.