Forum Discussion
Solved
How to Divide Two Calculated Measures?
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])
jovendeluna21 , I check the number is correct. in % term. I think you need sawp Numerator and denominator
1 Reply
jovendeluna21 , I check the number is correct. in % term. I think you need sawp Numerator and denominator