Using total value % & against row values %

[Anonymous]

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

[tackytechtom]

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.tackytech.blog

https://www.instagram.com/tackytechtom

[Anonymous]

Hi.

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

[tackytechtom · Accepted solution]

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

[ALLUREAN]

Hi, @Anonymous 

Please check this sample if understand correctly what you need.

https://www.dropbox.com/s/0925vkqy5hrslwq/Using%20total%20value%20%25%20%28allure-analytics.com%29.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/