Forum Discussion
JLambs20
Helper III
Helper IIIDifference between one value and average of all values using DAX
Hello, I need help with what seems like a straight-forward problem. I simply need to divide an individual weight (green highlight) by a group of value's average (yellow). So in this example, I need...
You can create a measure using ALLSELECTED to remove the row level context. Something like this should work:
Change = DIVIDE( SUM( Weight ) , CALCULATE( AVERAGE( Weight ) , ALLSELECTED( Value ) ) , BLANK() )
JLambs20Helper III
Helper IIIThat worked perfectly! Thank you so much!