Exercise - Set up a calculated measure
For this exercise, you're a consultant working on the implementation of Inventory Visibility for a client. The client uses Supply Chain Management. As such, the data source for Supply Chain Management is mostly set up. However, your client wants to use some calculated measures to improve their ability to query inventory. Your task is to set up this calculated measure for them.
Sign in to your Power Apps environment and open Inventory Visibility.
Open the Configuration page.
On the navigation pane, select Get Started.
Select Manage on the Feature Management tile.
Select Manage on the Inventory Allocation tile.
Select the Calculated Measure tab.
In the upper right of the tab page, select New Calculated Measure.
A form should open, where you can begin setting up your calculated measure. This calculated measure is for all ordered or on order inventory in fno. Therefore, you name this calculated measure Ordered of FNO. For the data source, select fno because the client uses Supply Chain Management.
Because you're getting totals, the Modifier is always Addition. Also, because you're aggregating across the fno data source, the Data Source is always fno (though, you can make calculated measures across multiple data sources). Your Measure starts with onorder, but you include more measures.
Select Save Measure to add the first measure.
In the lower left of your measure, select Add to add another measure.
Repeat step 6 for the availordered, ordered, and reserveordered measures. When you're finished, your calculated measure should resemble the following image.
