Forum Discussion
Conditional SUM
I have a dataset that looks like the following. For each ID there is an Attribute which has a score. There is also a target 0-4 with a weighting. I'm looking to create a visual with a diffe...
DaxBoi , As measures
new score = sumx(All(Table),[Target]*[Weighting])
or
new score = sumx(Allselected(Table),[Target]*[Weighting])
or
new score = calculate(sumx(Table,[Target]*[Weighting]),All(Table))
or
new score = calculate(sumx(Table,[Target]*[Weighting]),Allselected(Table))
diff = Sum(Table[Score]) -[new score]
As new column
new score = sumx(Table,[Target]*[Weighting]
diff = [Score] -[new score] //Both are column here