Forum Discussion
Percentage value is incorrect while dividing Calculated columns
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.
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
)
2 Replies
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
)Thanks Bhanu.
