Forum Discussion
Using total value % & against row values %
Hi.
I have the below index by row and would like to create column "yellow"
Need to create a total 2.06 and compare on each line.
Not sure how to create the total value and when I do this I get all rows also the one with no data.
Regards Mikael
Hi Anonymous ,
How about this:
TomsMeasureAverage = VAR _totalAverage = CALCULATE ( AVERAGE (Table10[Index] ), ALL ( Table10[Item] ) ) RETURN MAX ( Table10[Index]) - _totalAverage
Does this solve the issue? 🙂
/Tom
4 Replies
Hi Anonymous ,
I have a solution here:
I created a calculated column for this:
TomsColumnAverage = VAR _totalAverage = AVERAGE (Table[Index] ) RETURN Table[Index] - _totalAverage
Does this work for you? 🙂
/Tom
https://www.instagram.com/tackytechtom
Hi Anonymous ,
How about this:
TomsMeasureAverage = VAR _totalAverage = CALCULATE ( AVERAGE (Table10[Index] ), ALL ( Table10[Item] ) ) RETURN MAX ( Table10[Index]) - _totalAverage
Does this solve the issue? 🙂
/Tom
Hi, Anonymous
Please check this sample if understand correctly what you need.
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
