Forum Discussion
Measure for calculating user input forecasting
Hi
I was wondering if anyone had any cleever ideas on how to build a calculation which allows a user to input a value which could then in turn procude a visual which would show the knock on effect this would have on a supply chain.
So i have a list of highlevel products and thier sub-assemblies and in turn the sub-assembly suppliers.
I want the user to be able to input a 'demand' number and then in turn the report to show exactly how many orders need to be placed with subsequent suppliers...
so if i have the table
| Product | Sub Assembly | Qty | Sub Assembly Supplier |
| Prod 1 | Part 1 | 1 | Supplier A |
Part 2 | 2 | Supplier A | |
| Part 3 | 1 | Supplier B | |
| Part 4 | 1 | Supplier C |
So if the user was to input say deamand for Prod 1 is "10", i would want an output to show;
Supplier A - Part 1 = 10 units
Supplier A - Part 2 = 20 units
Supplier B - Part 3 = 10 unuits
Supplier C - Part 4 = 10 units
I would create a numeric parameter - see https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if and call it like "demand". This will create a slicer for your users to enter a demand value.
Then, you can create measure(s) for something like:
Product Demand = SUM(Qty) * SELECTEDVALUE(Demand[Demand Value])
Hope this helps
1 Reply
I would create a numeric parameter - see https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if and call it like "demand". This will create a slicer for your users to enter a demand value.
Then, you can create measure(s) for something like:
Product Demand = SUM(Qty) * SELECTEDVALUE(Demand[Demand Value])
Hope this helps