...
- Target Enrollment data don't change when the Cohort_Status (Continue and New) filter is clicked
- Add the sum of the Target Enrollment (The following Dax measures were used to add the sum:)
Max Target CN = MAXX(FILTER(a2_rm_pbi,a2_rm_pbi[Cohort_Status]="Continuing Student"),a2_rm_pbi[Target_by_Program])
Max Target NW = MAXX(FILTER(a2_rm_pbi,a2_rm_pbi[Cohort_Status]="New Student"),a2_rm_pbi[Target_by_Program])
Sum Traget CN = SUMX(VALUES(a2_rm_pbi[Program_Description]),[Max Target CN])
Sum Traget NW = SUMX(VALUES(a2_rm_pbi[Program_Description]),[Max Target NW])
Target Enrollment = [Sum Traget NW]+[Sum Traget CN]
Release 2022.1.1 [November 2022]
...