calculate percentange of yes and no based on their names , hoping a quick measure could help.

[Anonymous]

Hi, 

i'd like to get percentage of yes and no based on their names , here is the data :

Name	Attendance
Andy	Yes
Andy	Yes
Ben	No
Andy	No
Ben	Yes
Ben	Yes
Ben	No
Ben	Yes

and the result i want is divide based on the total name count. 

	Yes	No
Andy	67%	33%
Ben	60%	40%

[AlB]

Hi @Anonymous 

1. Place Name in the rows of a matrix visual

2. Place Attendance  in the columns the matrix visual

3. Place Attendance  in Values of the matrix visual. Choose Count and Show value as--> Percent of row total

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

@AlB , sorry. i'm actually looking for a method or quick measure for me to get the following answer .

	Total Count	% Yes ( # of Yes / total count)	% No ( # of No  / total count)
Andy	3	67%	33%
Ben	5	60%	40%

Do you know any formula for me to get that? thanks again.

[stevedep · Accepted solution]

Hi there,

Yes = CALCULATE(COUNTROWS('Table');'Table'[Attendance ]="Yes")/
CALCULATE(COUNTROWS('Table');ALL('Table'[Attendance ]))

No = CALCULATE(COUNTROWS('Table');'Table'[Attendance ]="No")/
CALCULATE(COUNTROWS('Table');ALL('Table'[Attendance ]))

File.

Kind regards, Steve. 

[Anonymous]

Awesome! thanks @stevedep ! 🙂 

[stevedep]

Welcome! Kudos appreciated (thumbs up)

[Anonymous]

Thanks AIB.

I want to use it for stacked column chart which allow to show Andy and Ben yes and no %. how do i do so? 

is there any quick measure formula allow me to find name "Andy" and count yes or no %?