Forum Discussion

jbrown184's avatar
jbrown184
Icon for Helper I rankHelper I
2 years ago
Solved

Convert Totals on Matrix to Average

Hi I am trying to Convert Totals on Matrix to Averages. The values is a count of specific column (Transactions). See below. How do I do this?    
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Measure 2 can be simplifies to:

    Measure 2 = AVERAGEX(GENERATE(VALUES('Location History'[Full Name]),VALUES('Location History'[Production Hour])),[Measure])

    Hope this helps.