How can I implement this decision maker?

[nicoenz]

Hi everyone, 

I am building a model to help me choose which container I need to use based on the material I want to ship and the average temperature of the sending and receiving ports. for a certain product if it's too hot say >30 degC (this threshold depends on the selected product) it needs to go on temperature controlled containers, else in ambient containers.

• Storage list table contains the data of the material to be shipped.
• Ports of Origin and Destination will retrieve the temperature from weather tables.
• Key measure calculates the average temp

The tables are not linked so i guess it's not possible but maybe someone has an idea...

Is there a way to achieve this?

I could do it in excel but translating it to here is proving quite difficult for me 😞

thanks!!!

[lbendlin · Accepted solution]

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

[Anonymous · Accepted solution]

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

[lbendlin · Accepted solution]

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