Forum Discussion
How can I implement this decision maker?
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!!!
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
2 Replies
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