Average total in tables

[mgalindo]

Hello Community I have a Issue with this datset

When create a table the total average is wrong

How I can do the correct calculate? Any idea?

[Anonymous]

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

[mgalindo]

Hello Nick, Yes I'm looking for 18.5

[Anonymous · Accepted solution]

try:

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

[mgalindo]

Thank You! Nick this works fine!