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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HotChilli 

Hi, I look at the link you have sent. I tried a couple examples hoping it might help. The examples I have tried from the link were not successful. 

This is what I have tried:

MinScoreMeasure = MINX ( SUMMARIZE ( ‘Table’, ‘Table’[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( ‘Table’, ‘Table’[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( ‘Table’, ‘Table’[Group] , "Measure",[YourMeasure] ), [Measure])

 

My goal, is to use average as shown below from the selection. As for the total average, shown in the second image, I want to get the accumulated total from the average numbers on the table.

 

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!