Forum Discussion

tortusstorylist's avatar
tortusstorylist
Frequent Visitor
3 years ago
Solved

Help keeping aggregate measures in a visual. Trying to compare individuals to average by category.

Hello,   I am trying to create a visual that has individual metrics, as well as the average of those same metrics by employee type.      As expected, the average measure is showing the ave...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    This measure works

    Measure = CALCULATE([HoursAverage],ALL(Sheet1[Staff Name]))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share the download link of the PBI file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      Hi,

      Is this the result you want?  Download the PBI file from here.

      Hope this helps.

      • tortusstorylist's avatar
        tortusstorylist
        Frequent Visitor
        3 years ago

        Hello,

         

        Thank you for looking at this. Unfotunately this does not acheive what I was looking for. What I am trying to do is to keep the overall average by Title in the second column in the first table. Here is a screenshot that might clarify: 

        Any additional help would be great.

         

        Thanks!