How can I implement this decision maker?

If you can do it in Excel, keep doing it in Excel.  Power BI is not a logistics planning tool.

HI nicoenz,

AFIAK, current power bi can create measure expression to show the correspond result based on condition and filter interactions in visuals, but it does not support to create dynamic calculate column/table based on filter effects. (they do not work on the same level and you can’t use the child level to affect their parent)

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng