Forum Discussion

apatnola's avatar
apatnola
Helper I
7 years ago
Solved

Count rows by Year

I want to figure out how to show each person's % of the total year in the stacked column chart below. Each color below represents the count for each employee. I want to show as a tool tip each color's % for that year.

 

So for light blue, the calculation would be 2550/13,769.

Tips and Tricks
  • JIGAR's avatar
    JIGAR
    7 years ago

    apatnola 

     

    You can create 3 measures

     

    1. TotalCount = CALCULATE(COUNT(Table[Column]))

     

    Use this 1st measure as value

     

    2. TotalCountForAllEmployees = CALCULATE(COUNT(Table[Column]),ALL(Table[Employees]))

     

    3. %CountPerEmployee = DIVIDE(TotalCount,TotalCountForAllEmployees)

     

    Use this 3rd measure as tooltip.

     

    I assume you are using Employees as Legend values.

     

    Attached is a example of how this is going to look. I am using Region instead of Employees. 

     

    Hope this helps !!

     

    Thanks

     

     

5 Replies

  • JIGAR's avatar
    JIGAR
    Resolver IV
    7 years ago

    apatnola 

     

    You can create 3 measures

     

    1. TotalCount = CALCULATE(COUNT(Table[Column]))

     

    Use this 1st measure as value

     

    2. TotalCountForAllEmployees = CALCULATE(COUNT(Table[Column]),ALL(Table[Employees]))

     

    3. %CountPerEmployee = DIVIDE(TotalCount,TotalCountForAllEmployees)

     

    Use this 3rd measure as tooltip.

     

    I assume you are using Employees as Legend values.

     

    Attached is a example of how this is going to look. I am using Region instead of Employees. 

     

    Hope this helps !!

     

    Thanks

     

     

    • apatnola's avatar
      apatnola
      Helper I
      7 years ago

      Thank you for the clear response. Worked like a charm!