Forum Discussion

Mous007's avatar
Mous007
Icon for Helper IV rankHelper IV
6 years ago
Solved

convert measures to column for correct average.

Hi all,   I have two measures created and they are workiing fine for me so far. i tried to average one of them but i am getting the wrong average. My measures are below: 1st to count difference ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Assuming you have only measures in 'Measures Table', that will not work.  Typically, you would use AVERAGEX() to iterate over a Dimension table or a virtual table like VALUES() or SUMMARIZE().  For example,

     

    Measure = AVERAGEX(DimensionTable, [YourMeasure])

     

    Measure2 = AVERAGEX(VALUES(Product[ProductID]), [YourMeasure])

     

    What is your goal in averaging over the Measures table?

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Assuming you have only measures in 'Measures Table', that will not work.  Typically, you would use AVERAGEX() to iterate over a Dimension table or a virtual table like VALUES() or SUMMARIZE().  For example,

 

Measure = AVERAGEX(DimensionTable, [YourMeasure])

 

Measure2 = AVERAGEX(VALUES(Product[ProductID]), [YourMeasure])

 

What is your goal in averaging over the Measures table?

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Mous007's avatar
Mous007
Icon for Helper IV rankHelper IV
6 years ago

Hi mahoneypat , I had a table with the request number and the working days needed to complete each single request. 

 

So based on your reply, i realized that I had to switch my measures from the measures tables to the actual data table. i used the same average calculation and now the average is calculated correctly.

 

Thanks a lot for the concept clarification.

 

Best,

Mous