Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
stlrivals
Regular Visitor

Struggling to get Power BI to Match an Excell Pivot Table

 
7 REPLIES 7
stlrivals
Regular Visitor

11

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?

1

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

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
Super User
Super User

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

 

lbendlin_0-1725496458500.png

Looks correct to me.

 

1

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.