Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 g...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi.

I am using a calculate measure and not able to use average as above.

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

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

https://www.tackytech.blog

https://www.instagram.com/tackytechtom