Getting the score column into a custom BI learning plan report

Summary

Getting the score column into a custom BI learning plan report

Content

With the announcement that the classic report builder will be retired next year, I'm working on re-creating our standard learning plan report template in BI reporting. I'm almost there, but I'm really struggling to get the score column (for mapped courses) to behave properly in this report.

Our standard report template that we offer to our clients is one that shows completion data for all learning plans mapped to their active employees, showing that status, score, and completion date for each mapped course. (Each client gets its own sub, so these don't get too big and unwieldy.) The classic report builder does this easily right now, including clearing the score for courses in recurring learning plans set to ignore previous completions. So I assume this is possible in BI.