Sum of Calculated Column

0
votes

I have calculated column Importance_Weight of which I need to create measure that sum questions for related line number.

Importance_Weight = (ColumnX * Average(ColumnY) )/100

Calculated column values for each question is correct as below but when aggrigated by line number the sum is wrong as blow

enter image description here

I used following measure to calculate sum of questions (q) i.e. L1

LT_WeightPerQuestion:=SUMX(DimQuestion, AVERAGE(Survey[Importance_Weight]))

Thanks in advance.

1
powerbidax

1 Answers

0
votes

Use measure as below

LT_WeightPerQuestion = SUM(Survey[Importance_Weight])

enter image description here