https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-a-Formula-that-Auto-Divide-Data-with-limitation/m-p/2002954#M44481 <P>Please provide sample data in usable format (not as a picture) and show the expected outcome.</P> Fri, 06 Aug 2021 18:21:46 GMT lbendlin 2021-08-06T18:21:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-a-Formula-that-Auto-Divide-Data-with-limitation/m-p/2001700#M44445 <P>Hi. I am fairly new to Power BI and its great function.</P><P>I've a data set here, where I need to divide the projects between the students. However, the rewards received must be &lt;= 100.</P><P>And Project No.AA4 must only be assign to John.</P><P>&nbsp;</P><P>I've tried some ways but its not working. Makes me wonder whether I can build the formula based on this data and limitation in PBI.</P><P>&nbsp;</P><P>Any idea or any thoughts on which functions I can use? Thanks.&nbsp;</P><P>&nbsp;</P><P><img /></P> Fri, 06 Aug 2021 07:09:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-a-Formula-that-Auto-Divide-Data-with-limitation/m-p/2001700#M44445 Anonymous 2021-08-06T07:09:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-a-Formula-that-Auto-Divide-Data-with-limitation/m-p/2002954#M44481 <P>Please provide sample data in usable format (not as a picture) and show the expected outcome.</P> Fri, 06 Aug 2021 18:21:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-a-Formula-that-Auto-Divide-Data-with-limitation/m-p/2002954#M44481 lbendlin 2021-08-06T18:21:46Z