Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI Table Average Total Incorrect

Hi, I selected a table from the visualization options. After adding my columns as an average rather than sum, I am receiving the wrong total. If that is just the way the calculation works for averag...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Using values('Table[name]) instead,see below example:

    Measure total = SUMX(VALUES('Table'[Name]),[Measure])

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi Anonymous ,

 

You should use SUMX instead of "MINX"," MAXX" and "AVERAGEX",as you wanna  correct the total value of the average result.

Check my sample .pbix file attached.

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-kelly-msft, 

 

Thanks for working on this with me. I know you use dates to break down the average as shown below. I am not using any dates. Which I find your calculation to be a little harder. How can we replace your date calculation to just Names?

 

Your measure:

HL R12 CY = calculate (
AVERAGE('Datas Vol'[Total Volume]),
DATESBETWEEN( 'Dates'[date],
max( 'Dates'[Date])- 365,
max ('Dates'[Date])))
 
  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  Anonymous ,

     

    Using values('Table[name]) instead,see below example:

    Measure total = SUMX(VALUES('Table'[Name]),[Measure])

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!