How to get an exact value in power Bi Report using Measures and Table Columns

[Charu]

Hi Everyone,

I got an issue getting the exact value in report, below are the calculations and measures I have used 

format for calculation1 is percentage and decimal value is 2
a) Calculation1 is a measure
b) Measure 1 is another measure and formula is
Measure 1 = CALCULATE (
SUM( Table [AMOUNT] ),
FILTER ( Table, Table[TAX] <> 0 || Table[TAX] <> BLANK() )
)
c) Calculation1 = (SUM(Table[Column 1])/[Measure 1])
example value : sum of Table[Column 1] = 443193.258213 and Measure 1 value = 6259604.89 so
443193.258213 / 6259604.89 = 0.07080211 (ie 7.08)
but in power bi report I'm getting the value as 7.12%

[Zubair_Muhammad · Accepted solution]

Hi @Charu

Try this

Calculation1 =
VAR mymeasure = [Measure 1] 
RETURN 
SUM ( Table[Column 1] ) / mymeasure