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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mgalindo
Frequent Visitor

Average total in tables

Hello Community I have a Issue with this datset

1.PNG

 

 

 

 

 

 

 

When create a table the total average is wrong

2.PNG

 

How I can do the correct calculate? Any idea?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

try:

SUMX( 
    VALUES( TABLE1[PRODUCT]),
    [AVERAGE]
)

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

9.25 is the average of that table with those filters. Are you looking for 18.5 there? or something else?

Hello Nick, Yes I'm looking for 18.5

Anonymous
Not applicable

try:

SUMX( 
    VALUES( TABLE1[PRODUCT]),
    [AVERAGE]
)

Thank You! Nick this works fine!

 

3.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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