Dax logic not working

[ClaudioF]

Hello again, its been a long month i am tring to find the problem in my code but i have no idea of whats going on. 

If anyone can help me with this it would be so good. 

I have two dashboards, both have the same code, the thing is, one is working with an excel file as source and the other has an internal source, i dont know if thats the problem root but thats the only difference between them. 

The dashboards: not working (ControleDaProducaoMaisLeve&BALSendDistribui.pbix) using excel source

Working well (Sum interval considering many filters11101.pbix) own source

the logic is, the stock might be distribuited to the orders in a way that it priorizes the orders with the lowest value (number) and if the item in the order has a value bigger than the remmaing stock (after being distributed to the orders that the quantity needed is <= to the stock) then, this orders will not be considered and other order with the item will be tested.. 

Thankyou all.

[v-huijiey-msft]

Hi @ClaudioF ,

To confirm if the issue is related to the source, you can export the data from the internal source to an Excel file and use it in a non-working dashboard, then see if the issue persists.

You can also:

Check that the field types (numeric, text, date, etc.) are the same in both the Excel source and the internal source; there may be null values or formatting irregularities in Excel.

Confirm that the table relationships and sorting rules in the two data models are identical.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!