Forecast coverage vs stock

Hello @ekoland88 ,

What is the structure of your table?

If the table structure is so, you can test the following measure.

Measure = 
var _not_stock_value = CALCULATE(SUM('Table'[values]),FILTER('Table','Table'[forecast]<>"stock"))
var _not_stock_count = CALCULATE(DISTINCTCOUNT('Table'[forecast]),FILTER('Table','Table'[forecast]<>"stock"))
var _stock_value = CALCULATE(SUM('Table'[values]),FILTER('Table','Table'[forecast]="stock"))
return
DIVIDE(
    _stock_value,
    DIVIDE(_not_stock_value,_not_stock_count))

If you don't meet your requirements, could you show the exact expected result based on the table we shared?

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

BTW, pbix as an attachment.