Forum Discussion

cmcgo3's avatar
cmcgo3
Helper II
2 years ago

Power BI Dax Random Function

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 ?