.

[Anonymous]

Hi @damonkimble ,

Could please provide some detailed screen shots about your tables and measures? I can't restore your scene.

It may be because you did not use the ALLEXCEPT function.  It removes all context filters in the table except filters that have been applied to the specified columns.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajulshah]

Hello @damonkimble ,

To get the total of the average values, you would need to create a covering measure that sums the average.
For example,
Total Average Cost = SUMX(VALUES(Items[Item]),[Average measure])

Hope this helps.

[parry2k]

@damonkimble not sure how you are doing it, you should also put item column on the rows.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡