79637191

Date: 2025-05-24 21:47:41
Score: 1
Natty:
Report link

Best Answer and it helped me too.

IF(
  HASONEVALUE('Table'[Quarter]),
  CALCULATE(AVERAGE('Table'[Sales]), ALL('Table'), VALUES('Table'[Quarter])))
Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Raja Govindan