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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Average of sums - logic of SUMMARIZE

Hello Everyone, I calculated the following measures: 

 

Yearly Average = AVERAGEX(SUMMARIZE('Fact table','Fact table'[Year]) ,[Production])
 
Then I calculated the same table as in the formula above: 
 
Table = SUMMARIZE('Fact table','Fact table'[Year],"Sum",[Production])
 
and then the following measures: 
 
Average X 2 = AVERAGEX('Table','Table'[Sum])
Average of sum = Average('Table'[Sum])
 
The issue is that the first measure works very well in the model. I can filter by many other dimensions and the value is getting updated, but the two remaining measures are not. Filters from dimension tables don't affect them. 
 
Can you explain to me the logic behind SUMMARIZE or AVERAGEX? Why does it work when I created a virtual table and doesn't work when I created a real, static table from the same syntax? measures2.JPG

 

measures1.JPG

 

model1.JPG

 

 
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous . Once you create a calculated table it can not take the slicer filters. You need to join it again with slicer/dimension tables (This is a static table build when you refresh data)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous . Once you create a calculated table it can not take the slicer filters. You need to join it again with slicer/dimension tables (This is a static table build when you refresh data)

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.