Forum Discussion

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

I didn't understand your solution. It looks correct but i don't know how use it.

 

Calculated column may work but I get value of 67.99 and 79.71 by (MeasureA-MeasureB)/MeasureA formula. So i don't know how can make a calculated column. MeasureA =SUM(Column1NUMBER) and MeasureB = DISTINCTCOUNT(Column2STRING) ( Also both of those columns are coming from different tables)

BTW; I use  Tabular as source and work Live on PowerBI.

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.