I am calculating chocolate yields over time. The yellow cells below show the kind of measures I need to create.
Question: I’ve modelled my data as shown - is this an advisable / feasible way to model my data in order to calculate the results I need? I’ve tried about 5 different attempts. I arrived at this design because it makes sense when I talk about it: One input of chocolate (eg a wheelbarrow) can produce one or more chocolate bars of different kinds. And each chocolate bar can have zero or more reasons to be scrapped. The reason I am also double checking my model is that the dax seems far from simple. It may just be because my dax skills need to be drastically improved. But I’m not 100% sure.
Is this model design, advisable? … is it just that my dax needs, ermm… a lot of work? (pbix and data are here Chocolate Yeilds.zip (84.4 KB) )
As always thank you,