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.

v-kkf-msft's avatar
v-kkf-msft
Community Support
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.

dmoggie's avatar
dmoggie
Helper I
5 years ago

Good Afternoon Winniz,

 

Thank you so much for your help.  Happy to confirm this is just what I required to progress my report.