Forum Discussion

ngaray's avatar
ngaray
Icon for Helper I rankHelper I
6 years ago
Solved

Using variables and HASONEVALUE() to calculate average in a matrix

Hello everyone,   I need to create a matrix that calculates the average of values instead of row total. I see this is a common issue in this forum. I was able to find other posts that got me close ...
Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi ngaray,

    try the following measure:

     

     

    Regards FrankAT

FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ngaray,

try the following measure:

 

 

Regards FrankAT

ngaray's avatar
ngaray
Icon for Helper I rankHelper I
6 years ago

Hi FrankAT 

 

Your measure worked perfectly!

I only modified the aggregation in the true portion of the If condition from Average to Sum. I should have clarified that I want to see the total hours by week not the average.

I can see that my problem was that I didn't filter the table by employee.

 

Thank you for your assistance, it is very much appreciated!

 

Nathalia