Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ahumke
Helper I
Helper I

RAND function how to randomly assign to groups

I'm trying to create a measure that will randomly assign people in my file to a treatment group or a control group if their score is above a threshold.  I've found the RAND command will generate a random number so I was thinking I could do a two step to assign groups.

 

Random Assignment = if ('Tuesday, July 7, 2020'[Weighted Average Score] > 3, RAND()*(2-1)+1)
Success Coach Assignment = if ('Tuesday, July 7, 2020'[Random Assignment] <1.50, "Yes")
 
This doesn't seem to be working though - each time I run the "Student Coach Assignment" field it seems to rerun the random assignment field - therby doing the Success Coach Assignment on the prior run values (meaning the assignment rule isn't followed) and the other problem is that once a person is assigned a value I don't want it to change for that person. The data will get updated and refreshed periodically to add people but the individual person should remain the same and I don't want their values to change at all.
 
Is there a way to make it work that way?
 
Thanks!
3 REPLIES 3
harshnathani
Community Champion
Community Champion

Hi @ahumke ,

 

You can try this 

 

Random Assignment =
IF (
    'Tuesday, July 7, 2020'[Weighted Average Score] > 3,
    DIVIDE (
        'Tuesday, July 7, 2020'[Weighted Average Score],
        100
    ) * ( 2 - 1 ) + 1
)

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

 

edhans
Super User
Super User

Consider using List.Random inside of Power Query. It will only update on the refresh of the dataset, not as users are working in the report. Here is an article that shows how to do that



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.