Need percentages of string column based on another string column and put them in a line graph

[jteague]

I want percent status (retained) by gender as my y-axis and term as my x-axis.. I would prefer to drop the A (not retained) altogether from the graph. I tried concatenating gender and status and using this measure:

Measure = DIVIDE(COUNTA('retentionF17F23(gendercatx)'[gedret]),CALCULATE(COUNTA('retentionF17F23(gendercatx)'[gedret]),ALLSELECTED('retentionF17F23(gendercatx)'[gedret])))

But it is giving me percent of total for each group. I want x% of females and x% of males were retained per semester on the graph.

I would also prefer not to use gedret at all if possible.

Sample of the data:

race	gender	age_group	degree_type	Status	term	gedret
African-American	Male	30 and Over	College Transfer	A	Fall 2017	Male A
African-American	Male	30 and Over	Career / Technical	Retained	Fall 2017	Male Retained
African-American	Male	30 and Over	College Transfer	Retained	Fall 2017	Male Retained
African-American	Female	30 and Over	Career / Technical	Retained	Fall 2017	Female Retained
African-American	Male	30 and Over	Career / Technical	Retained	Fall 2017	Male Retained
African-American	Male	30 and Over	Career / Technical	A	Fall 2017	Male A
African-American	Female	30 and Over	College Transfer	Retained	Fall 2017	Female Retained
African-American	Female	30 and Over	College Transfer	Retained	Fall 2017	Female Retained
African-American	Male	30 and Over	Career / Technical	A	Fall 2017	Male A
African-American	Female	30 and Over	Career / Technical	Retained	Fall 2017	Female Retained
African-American	Male	30 and Over	Career / Technical	A	Fall 2017	Male A
White	Female	18-24	College Transfer	Retained	Fall 2017	Female Retained
White	Female	30 and Over	College Transfer	Retained	Fall 2017	Female Retained
White	Female	18-24	College Transfer	Retained	Fall 2017	Female Retained
African-American	Male	30 and Over	Career / Technical	A	Fall 2017	Male A
White	Male	30 and Over	Career / Technical	A	Fall 2017	Male A
African-American	Female	30 and Over	Career / Technical	Retained	Fall 2017	Female Retained
White	Female	30 and Over	Career / Technical	A	Fall 2017	Female A

[Ashish_Mathur]

Hi,

Based on the sample data that you have shared, show the expected result.

[jteague]

Thank you for the reply.

Using variables gender and  status I would like the result:

Male : retained = 33% A= 67%

Female  :retained= 89% A= 11%

[Ashish_Mathur]

I cannot understand your expected result.  Someone who does will help you.

[jteague]

gender		Status
Male		A
Male		Retained
Male		Retained
Female		Retained
Male		Retained
Male		A
Female		Retained
Female		Retained
Male		A
Female		Retained
Male		A
Female		Retained
Female		Retained
Female		Retained
Male		A
Male		A
Female		Retained
Female		A

percentage = DIVIDE(COUNTA('retentionF17F23(2)'[Status]),CALCULATE(COUNTA('retentionF17F23(2)'[Status]),all('retentionF17F23(2)'[Status])))

By using the measure above I can get overall retention rates. I want to further disagregate it by gender as well.

In the sample data there are 9 males and 9 females. Of the 9 males 3 were retained =33%

of the 9 females 8 were retained 89%. Hopefully that makes it easier to understand for everyone.

[Ashish_Mathur · Accepted solution]

Hi,

These measures work

Members = COUNTROWS(Data)

Retained = CALCULATE([Members],Data[Status]="retained")

Retention rate = DIVIDE([Retained],[Members])

Hope this helps,

[jteague]

Worked perfect. Thank you! Anyone know of any free resources for Power BI training?

[jteague]

I have been able to get to the chart below using this measure:

percentage = DIVIDE(COUNTA('retentionF17F23(2)'[Status]),CALCULATE(COUNTA('retentionF17F23(2)'[Status]),all('retentionF17F23(2)'[Status])))

 But I need it to look like this:

 I achieved this by dividing the (retention percentage by gender) by number of students and using sum but then it will not work with slicers.