Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone!
Will appreciate any help if it's even possible to solve the question
I'm trying to make a model, which will show, how would change the final cost of a dish after changing of the cost of some of it's ingredients.
1. I have a list of dishes (burgers), each of those burgers is consist of some ingredients, sometimes ingredients are unique, sometimes - not. Cost of the burger is calculated as a sum of costs of it's ingredients.
2. Also I have a list, where shown, which and how many ingredients are in particular burger.
3. And one more list of all ingredients with it's cost for 1 piece
The problem is that I need to have an opportunity to change cost for a several ingredients separately at one time. For example, for onion +10%, for bread +3% and so on.
To be able to choose different ingredients I've made a few supported blocks: green, meat, bread, sauce, other. And one supported table of all ingredients together, called "Filter Cost of ingredients". There no relations between them.
As I see the further process, I need to choose some ingredients in each block and change the cost via What-If parameter. After that need to get changed cost of particular ingredient (cost for which was changed) into the full table of ingredients (step 1 on screenshot). And if ingredient is not selected and cost of it is not changed, so in this column we need to note it's standart cost. So after step 1 we have a table with one column (measure) with changed costs and standart costs.
At step 2 I will compare Fact costs with Model costs. And at step 3 I will collect Fact and Model cost of every burger and will be able to compare it.
So, the main problem is how to achieve step 1 is working. I don't even know is it possible and will be glad to any thoughts and help.
Here is the link to .pbix file
https://www.dropbox.com/s/kubatkmky6kh7di/Share_Model_2.pbix?dl=0
Thanks!
Solved! Go to Solution.
Hi @D3K
you can download the pbix file here: https://1drv.ms/u/s!AiiWkkwHZChHjx6QGS8z8QHzSMGu
also if you click on the link in my first post you can check online the new report
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |