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?
  • Anonymous's avatar
    Anonymous
    7 years ago

    try:

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