Creating a dynamic table based on on-screen filters

Here's the full solution.

First, the model:

The model

Then, the report:

The report

And here are the measures:

# Available Items = SUM( 'Item Availability'[Item Count] )

# Items Needed = SUM( 'Projects'[Item Count] )

Availability = 
var __itemsNeeded = [# Items Needed]
return
if( __itemsNeeded > 0,
    var __itemsAvailable = [# Available Items]
    var __result =
        if( __itemsAvailable >= __itemsNeeded,
            1,
            DIVIDE( __itemsAvailable, __itemsNeeded )
        )
    return
        __result + 0
)

Best

D