Struggling to get Power BI to Match an Excell Pivot Table

[stlrivals]

11

[lbendlin]

what I am trying to do is get the total of the averages into another column

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.

What is your expected result, and why?

[stlrivals]

1

[Anonymous]

Hi,@stlrivals 
Excuse me, was his answer helpful?

If it's helpful, you may consider marking lbendlin's answer as a solution, so that community members in the community who have similar questions to you can find the answer more quickly.

Thank you in advance for your contribution to the community.
 

Best Regards,

Leroy Lu

[lbendlin]

Great - now that you have documented the process you can implement it step by step in your measure.  Read about aggregation functions like SUMX. 

[lbendlin]

Why would you think the totals are wrong?  What is your expected result?

Looks correct to me.

[stlrivals]

1