Building the supply chain inventory dashboard
We will reuse the steps and what we learned from building the other two dashboards, so I won’t do an elaborate repetition of what I already explained in previous paragraphs. The data model for the supply chain dashboard we built in the previous chapter is shown in the following screenshot:
Figure 11.24 – An overview of the supply chain dashboard data model
To achieve the dashboard we want, we will start by creating seven measures – six in the Production ProductInventory table and one in the Production Product table. The measures are listed as follows:
Products:=DISTINCTCOUNTNOBLANK('Production ProductInventory'[ProductID])to get the total count of products in the company’s warehousesIn Stock:=CALCULATE(DISTINCTCOUNTNOBLANK('Production ProductInventory'[ProductID]),'Production ProductInventory'[Stock Status]="In Stock")to get...
