Forum Discussion
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...
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 .
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.
I believe you want:
Measure =
VAR __Sum1 = SUMX(FILTER('Table',[Category] = "Initial Request"),[Value])
VAR __Sum2 = SUMX(FILTER('Table',[Category] = "MSPC Approved"),[Value])
RETURN
(__Sum1 - __Sum2) / __Sum1
Now, you may run into the issue where this measure ends up getting added multiple times. You can get around that by using something like this: