topic Re: calculate percentange of yes and no based on their names , hoping a quick measure could help. in DAX Commands and Tips

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

Anonymous — Wed, 03 Jun 2020 14:15:49 GMT

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%

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

AlB — Wed, 03 Jun 2020 14:34:00 GMT

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

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

Anonymous — Wed, 03 Jun 2020 14:57:35 GMT

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 %?

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

Anonymous — Wed, 03 Jun 2020 15:10:19 GMT

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

67%

33%

Ben

60%

40%

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

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

stevedep — Wed, 03 Jun 2020 15:27:35 GMT

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.

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

Anonymous — Wed, 03 Jun 2020 15:47:11 GMT

Awesome! thanks stevedep ! 🙂

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

stevedep — Wed, 03 Jun 2020 16:50:23 GMT

Welcome! Kudos appreciated (thumbs up)