topic Re: Calculating Continuation percentages in DAX Commands and Tips

Calculating Continuation percentages

ZakariAK — Wed, 08 May 2024 08:23:32 GMT

Hi,

I have a table with student registries from different years, i already have the counts by the ID column, but I want to calculate the percentage of students from each studies in each academic years that continue their studies in the next year.

Thanks in advance,

Re: Calculating Continuation percentages

bhanu_gautam — Wed, 08 May 2024 09:10:35 GMT

ZakariAK ,You can create a measure for continuing students

Total Students = COUNT('YourTable'[Student ID])

Continuing Students =
CALCULATE(
COUNT('YourTable'[Student ID]),
FILTER(
ALL('YourTable'),
'YourTable'[Academic Year] = EARLIER('YourTable'[Academic Year]) + 1
&& 'YourTable'[Study] = EARLIER('YourTable'[Study])
)
)

Create a new measure to calculate the percentage of students who continue their studies:

Percentage Continuing = DIVIDE([Continuing Students], [Total Students]) * 100

This will display the academic year, study, total number of students, number of students continuing their studies in the next year, and the percentage of students continuing for each combination of academic year and study

Re: Calculating Continuation percentages

Anonymous — Fri, 10 May 2024 05:41:05 GMT

Hi ZakariAK ,

I create a table as you mentioned.

Then I create a calculated column named Percentage.

Percentage = VAR _Total = COUNT ( Students[ID] ) VAR _Continue = CALCULATE ( COUNT ( Students[ID] ), FILTER ( ALL ( Students ), 'Students'[Study Area] = EARLIER ( Students[Study Area] ) && 'Students'[Academic Year] = EARLIER ( Students[Academic Year] ) ) ) RETURN DIVIDE ( _Continue, _Total, 0 )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.