I would like to calculate the average of the baseline assessment for just the common standards. In this case, it should be the average of 7.1, 7.2 and 7.3. I would also like to calculate (nonbaseline) exam score for common standards. Again, just 7.1, 7.2 and 7.3. These will go into single value cards to show improvement from common standards.
Unfortunately, I cannot share the PBIX file due to confidential exam data.
I also think share some same data will help us clarify your data structure and test to coding formula.
In fact, we do not need the real data, you can keep the raw table structure and build some dummy data to share. (e.g. use random value to replace the raw numerical values, replace sensitive string with test,123...)
I want to be able to calculate the improvement from Baseline exam to other Non-Baseline exams with identical sections. (I.E: a score of 50% for baseline section 1.1 to the 75% for English 101 section 1.1.
The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. Appreciate your Kudos.