Count rows by Year

[apatnola]

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.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[JIGAR]

Hi,

You can download the PBI file from this location

https://drive.google.com/open?id=16TOpguo6yv-Z0IByBadWmiJAauGgxM1h

[Ashish_Mathur]

Hi,

I believe your question has been answered.  Therefore i am not downloading your file.

[JIGAR · Accepted solution]

@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]

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