Complex conditional summing
Hey everyone! how you doing? I have been now a month trying to make this logic work in dax but no solution. Cna anyone please help me with this? or even just say that power Bi will not be able of doing it happen? Here is the thing: I need to distribute evenly the stock of an item throught the orders of this item, in a way that the result is as shown in the table bellow: I need the stock to be distributed in a way that when its not enought to the order it will try to fit in the other order until the total stock is used. Use the stock amount of 21 for this example, you will see that the ones set as available, when summed will be exactly 21. The status column is the outcome that i need from the dax code. This is very hard, i don't even know if its possible; can anyone please helpe me with it? Thankyou a lot allready.Measure the relevance of i item
Hello there again, I need to find out how to calculate the relevance of an item compared to the general value. i have here the dashboard for you to download (ControleDaProducaoMaisLeve&BALSend.pbix) and see. What i need is the item in the visual table to be tested to see its relevance compared to the others, the logic is: if i remove this item, or not consider it, or filter all but leave it out, will the amount of "CountAvailable01" still be the same or it will decrease compared to the value on the card "Ped. Com Potencial"? if it decrease, the item is somehow relevant, if it does not do any difference its no important, a whay to measure the amout is the formula (1-"Ped. Com Potencial"/"CountAvailable01"); with that i will have a percentage of how important that item is to the general situation.. It might feel a little confuse, hope you guys can help me, i've allready tried a lot and used all AI i could to help me. Thankyou a lotDax logic not working
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.
