How to Divide Two Calculated Measures?

[jovendeluna21]

Hello,

I want to divide two calculated measures but it is giving me wrong percentage.

Here's the calculation for:

Tonnes CO2 =

IF (HASONEFILTER(Mode[Mode]),

CALCULATE(MAX('Raw Data'[g CO2/ tonne-km])*[Tonnes-kms])/1000000,

CALCULATE(MAX('Raw Data'[g CO2/ tonne-km])*[Tonnes-kms],'Raw Data'[MODE]="Parcel")/1000000 +

CALCULATE(MAX('Raw Data'[g CO2/ tonne-km])*[Tonnes-kms],'Raw Data'[MODE]="Air Cargo")/1000000 +

CALCULATE(MAX('Raw Data'[g CO2/ tonne-km])*[Tonnes-kms],'Raw Data'[MODE]="Ground")/1000000 +

CALCULATE(MAX('Raw Data'[g CO2/ tonne-km])*[Tonnes-kms],'Raw Data'[MODE]="Ocean")/1000000)

then for other one:

Net Sales SUMMARY = SUMX(SUMMARIZE('Raw Data','Raw Data'[Concat],"Net Sales",MIN('Raw Data'[Net Sales])),[Net Sales])

[amitchandak · Accepted solution]

@jovendeluna21 , I check the number is correct. in % term. I think you need sawp Numerator and denominator