measure with IF and filter context

[kelsenfaria]

Here is my model :

Using this measure I can filter dProduto related to fPedidoVenda only as we can see from table image.

Medida = CALCULATE(SUM(fOP[QT_PENDENTE]) + SUM(fOP[QT_PEND_REPROCESSO]) + SUM(fEstoque[QTD ESTOQUE]) - SUM(fPedidoVenda[QT PENDENTE]))

 

Now I'm trying to use a condition with a IF statement but is not filtering only dProduto related to fPedidoVenda anymore, instead it is showing all dProduto table.

IF(CALCULATE(SUM(fOP[QT_PENDENTE]) + SUM(fOP[QT_PEND_REPROCESSO]) + SUM(fEstoque[QTD ESTOQUE]) - SUM(fPedidoVenda[QT PENDENTE])) > 0, "DISPONIVEL", "NAO ESTA DISPONIVEL")

 

[kelsenfaria]

Tables images are not correct.

Here is table without IF statement.

And with IF statement :

 

[v-easonf-msft]

Hi， @kelsenfaria 

After review and research, I am still confusing about your requirement, do you mind  providing a sanitized sample pbix file and  expected output so it will be easier to suggest possible approaches?

Best Regards,
Community Support Team _ Eason