Forum Discussion

dkc's avatar
dkc
Helper I
4 years ago
Solved

Fixed measure value

Hi there, so far I did not find yet a working solution for following problem (sorry, I am new to Power BI): I would like to create a measure "overall average" which also shows up in matrix view in ea...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    Hi dkc Try this:

     

    Average = AVERAGEx(ALLSELECTED(TeamTable),TeamTable[Contacts])

     

    full table

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
4 years ago

Hi dkc Try this:

 

Average = AVERAGEx(ALLSELECTED(TeamTable),TeamTable[Contacts])

 

full table

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel