Hello,
I work on a project in which depending on the selected material user has to assign loss lvl 1,2,3
The current logic works as follows.
In dropdown for lvl 1 there is a suggested value calculated by an algorith - this works - but users still should be able to see all possible lvl 1 losses in case they wanted to change it - idk how to make it work
for now datasource is PowerBIIntegration.Data.suggested_LVL1_loss - but of course it shows only the suggested value, idk how to make it flexible and show this value but enable users to change it for any value from a SQL table
In dropdown lvl 2 I would like to show all possible loss level 2 that correspond to the selected value in dropdown 1
The rule is it starts with the same number. So if selected value in loss 1 is 1.Commercial Delay then in loss 2 I should be able to see lvl 2 losses starting with number 1, for instance 1.2 Supplier delay. The source for all losses is a SQL table.
I tried the following Filter('[Map].[Loss_type]';LVL_type="2").Loss_type - this shows ALL loss lvl2 but idk how to narrow them down to those starting from the 1st number from the value of Dropdown 1
Does anyone has any idea? Attached picture for references. I will be very grateful for any suggestion on how to solve it.
Best regards
Konrad
