Hello, I have a list of 800 total students on the left that is filtered to "low" based on test scores 25 and below. I am trying to create a random list of students on the right who have low scores, say 5 students for each week or day, that doesn't repeat that same student (non-repeating) for 7 days. Also, I would like the list on the right not to change. I noticed when using the random function in DAX, when dashboard refreshes, those names will change. Is there any way to accomplish this ?
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
