Forum Discussion

MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
8 years ago
Solved

Average of Average

Hi all,   I'm having trouble while making an 'average of an average'. I see many people asking this here, but I can't find anything that solves my problem....   I'm having this data:   Wh...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi MiKeZZa

     

    Create a new MEASURE as follows which will refer your original MEASURE

     

    Measure 2 =
IF (
    HASONEFILTER ( emp[Name] ),
    [Measure],
    AVERAGEX ( ALLSELECTED ( emp[Name] ), [Measure] )
)
MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
8 years ago

Exactly what I was looking for!