Forum Discussion

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi aslan,

Calculated column may work but I get value of 67.99 and 79.71 by (MeasureA-MeasureB)/MeasureA formula.

Instead of using (MeasureA-MeasureB)/MeasureA, could you try the formula below to see if it works to get the right Grand Total you need?:smileyhappy:

Percentage = SUMX ( 'TableName', ( [MeasureA] - [MeasureB] ) / [MeasureA] )

Note: The 'TableName' is the name of your table whose column you're showing on the Table/Matrix with the Percentage measure.

 

Regards

aslan's avatar
aslan
Icon for Helper I rankHelper I
9 years ago

Hi v-ljerr-msft

It doesn't work. I am getting very small value in PowerBI.