Inventory Availability Coverage

Fun question! I have created the following calculated table that results in what you want:

Table 2 = 
ADDCOLUMNS(DATATABLE("Stock", STRING, {{"Yes"}, {"No"}}), "% Available",
    VAR _tmpTable = SUMMARIZE(Inventory, Inventory[Product], "TotalInventory", SUM(Inventory[Quantity]))
    VAR _rowsOnStock = COUNTROWS(FILTER(_tmpTable, [TotalInventory] > 0))
    VAR _rowsNotOnStock = COUNTROWS(_tmpTable)-_rowsOnStock
    VAR _totalProducts = COUNTROWS(_tmpTable)
    RETURN
    IF([Stock] = "Yes", 
        DIVIDE(_rowsOnStock, _totalProducts), 
        DIVIDE(_rowsNotOnStock, _totalProducts)
    ))

What this does is the following. DATATABLE creates a single column table with Yes and No rows. Then I add a column to it called "% Available". I then create a summarytable in memory of the Inventory table. This results in a table of two columns, one with Products and one with the sum of inventory of that product. Then I count the rows where inventory is 0 and where not. Finally, if the current row is "Yes" I divide rowsOnStock by totalProducts. If "No", I divide rowsNotOnStock by totalProducts.

Result is this:

Original valuesAdjusted formatting on the column to represent percentages

Let me know if this suits your needs. If you want it to be dynamic (e.g. a table visual), then we need another aproach. 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

I took the following approach. Note that this answers if you have stock in any warehouse, not all warehouses as you stated, but your results of 25%/75% seemed to indicate it was any warehouse.

1) I created a simple table to get a Yes/No based on stock:

Stock Status = 
SUMMARIZE(
    Inventory,
    Inventory[Product],
    "On Hand",
        VAR IsInStock=
            CALCULATE(
            SUMX(
                Inventory,
                IF(Inventory[Quantity] > 0, 1, 0)
            )
            )
        RETURN
        IF(IsInStock > 0, "Yes","No")
)

It returns this table:

Then I related that table to your inventory data as shown:

Then I created a table visual, dropping in the "On Hand" field from the Stock Status table, and the Percent Available measure from the INventory Table, which is the following measure:

Percent Available = 
VAR ProductCount =
    COUNTROWS(
        DISTINCT( Inventory[Product] )
    )
VAR TotalProductCount =
    COUNTROWS(
        ALL( Inventory[Product] )
    )
RETURN
    DIVIDE(
        ProductCount,
        TotalProductCount,
        0
    )

my PBIX file is here if you want to tinker with it.