Forum Discussion
Help building a random assignment logic to my contracts table
juliamacg_ this would be very ugly and involve some pretty heavy DAX to accomplish.
You'd also have to randomly assign contracts to this person instead of that based on status. And based on a given allocation from step one, you'd have to define rules for each person as allowed to have up to a certain threshold of contracts of a certain status. And then you'd have to have a third set of rules to make sure that any given person wasn't overloaded on any given status. And finally, I would assume a fourth set to make sure the allocation was optimized.
It could probably be done, but the DAX involved is going to be really, really intensive to accomplish. If you have access to other platforms (Python, R, SQL) I'd suggest doing the heavy lifting there and pulling the results into Power BI...or skip Power BI all together.
Just my two cents...
Community Championjuliamacg_ this would be very ugly and involve some pretty heavy DAX to accomplish.
You'd also have to randomly assign contracts to this person instead of that based on status. And based on a given allocation from step one, you'd have to define rules for each person as allowed to have up to a certain threshold of contracts of a certain status. And then you'd have to have a third set of rules to make sure that any given person wasn't overloaded on any given status. And finally, I would assume a fourth set to make sure the allocation was optimized.
It could probably be done, but the DAX involved is going to be really, really intensive to accomplish. If you have access to other platforms (Python, R, SQL) I'd suggest doing the heavy lifting there and pulling the results into Power BI...or skip Power BI all together.
Just my two cents...