Data Dictionary
Below is a list of calculations made in the Power BI report using DAX measures and calculated columns. The code for the measure or column can be used to translate to other tools (Tableau, etc.).
Last updated
Below is a list of calculations made in the Power BI report using DAX measures and calculated columns. The code for the measure or column can be used to translate to other tools (Tableau, etc.).
Last updated
To access the downloadable excel file, access the gitHub link below:
Measure
AssessmentParticipatingK12IdeaPercentREDACTED
1
Calculation for the percent of IDEA students who participated in the state assessment. Value is suppressed for count of participating IDEA students less than 10.
Measure
AlternateAssessmentK12IdeaPercentREDACTED
2
Percent of IDEA students who have participated in the alternate state assessment. Value is suppressed for count of IDEA students taking the alternate assessment under 10.
Measure
AlternateAssessmentK12StudentPercentREDACTED
3
Percent of all students who have opted to take the alternate state assessment. Value is suppressed for count of K12 students taking the alternate assessment under 10.
Measure
AssessmentProficientK12IdeaProportion
4
Percent of IDEA students who scored proficient on the state assessment.
Measure
AssessmentProficientProportion
4
Percent of all students who scored proficient on the state assessment.
Measure
AssessmentProficientK12IdeaPercentREDACTED
5, 6, 7
The percent of IDEA students who have scored proficient on the state assessment. Value is suppressed for count of IDEA students who scored proficient on the state assessment under 10.
