Using a few selections while modelling

LivioLanzo

Firstly, I want to say, that your report looks great, even better than I've constructed in my mind as the final result! 

And it works almost perfect:

- costs for chosen ingredients changes for all other dishes

- and the cost of burger is also calculating correctly

Thanks!

But check it out to got what I'm trying to explain. Imagine that supplier increase price only for chicken, and the price for beef wasn't change. And we need to increase only cost for chicken and don't touch cost of the rest meat ingredients. And after that we'll see how is changing cost of burgers with chicken.

That's why I've separated ingredients for blocks: choose Chicken from Meat block and increase, choose Onion from Green block and change the cost. 

And I saw the possibility that when any block is filtered and one of it's ingredients is selected - to put changed value into the cost model column. But my knowledge in DAX is not enough to make it, that's why I'm here

Anyway I'm really impressed with the current result it's awesome :)