Forum Discussion

dmoggie's avatar
dmoggie
Helper I
5 years ago
Solved

Matrix Help. Avg instead of Total

Hi, I have created a matrix with Max values. I need to display the avg of these values instead of the Max value in the Totals field. I know I can create the matrix using avg figures, but that is not...
Need Help
Tips and Tricks
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi dmoggie ,

    Try the following formula:

    Measure = 
IF(
  HASONEVALUE('Table'[Date]),
  MAX('Table'[Value]),
  AVERAGE('Table'[Value])
)

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi dmoggie 

 

Download example PBIX

 

Have you written a measure to get the MAX ?  If so then rewrite to use AVERAGE e.g.

 

 

Average 11:00 = AVERAGEX ( 'Table','Table'[11:00:00])

 

 

 

If your matrix has values in the Values wells, chnage the aggregation to Average

Regards

Phil

dmoggie's avatar
dmoggie
Helper I
5 years ago

Hi Phil,

 

Thank you for taking time out to answer my query. unfortunately this is not realy what I am after.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Share the link from where i can download your PBI file.