Percentage value is incorrect while dividing Calculated columns

[Kumar_0606]

Hello Experts,

I am trying to divide 2 calculated columns to get the percentage but getting wrong result.

 Calculated column1= IF (Table[Version] = "New" && Table[Code] = "ABC" && Table[Year] < 2022, (Value]).

Likewise created column2 and tried 

DIVIDE(Calculated column1, Calculated column2) getting wrong values.

I tried creating a New Measure like

Calculated column1= If ( MAX (Table[Version]= "New" && MAX ( Table[Code] = "ABC" && Table[Year]< 2022, SUM(Value) , the value displayed is Blank.

Thanks in advance.

[bhanu_gautam · Accepted solution]

@Kumar_0606 Instead of creating a calculated column for the division, it's better to create a measure. Measures are more dynamic and can handle aggregations better.

DAX
Measure1 = SUM ( Table[CalculatedColumn1] )
Measure2 = SUM ( Table[CalculatedColumn2] )

PercentageMeasure = DIVIDE ( [Measure1], [Measure2], 0 )

If you want to create a measure that sums values based on conditions, you should use the CALCULATE function.

DAX
Measure1 = CALCULATE (
SUM ( Table[Value] ),
Table[Version] = "New",
Table[Code] = "ABC",
Table[Year] < 2022
)

[Kumar_0606]

Thanks Bhanu.