cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mgalindo Frequent Visitor
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

Accepted Solutions
Nick_M New Contributor
New Contributor

Re: Average total in tables

try:

SUMX( 
    VALUES( TABLE1[PRODUCT]),
    [AVERAGE]
)
4 REPLIES 4
Nick_M New Contributor
New Contributor

Re: Average total in tables

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

mgalindo Frequent Visitor
Frequent Visitor

Re: Average total in tables

Hello Nick, Yes I'm looking for 18.5

Nick_M New Contributor
New Contributor

Re: Average total in tables

try:

SUMX( 
    VALUES( TABLE1[PRODUCT]),
    [AVERAGE]
)
mgalindo Frequent Visitor
Frequent Visitor

Re: Average total in tables

Thank You! Nick this works fine!

 

3.PNG