Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Average total in tables

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?

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    try:

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Nick, Yes I'm looking for 18.5

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        try:

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