Reasons why totals of a measure doesn't match what is in a a table

[Anonymous]

Hello

I have such an issue. My measure gives me a total that is 505,586. However, the column itself for the orders that I have in table is blank therefore I expected the total to be 0 as well. 

I am trying to understand why it happens and how it is possible to fix it. If we have 0 I believe I should have 0 and not a different number. 

[Shishir22]

Hi @Anonymous ,

Can you please share pbix after hiding sensitive data?

Cheers,

Shishir

[Anonymous]

@Shishir22 thank you very much. I unfortunately have the same issue still. 

[Shishir22]

Hello @Anonymous ,

Can you please try below code -

Open PO (On Order) = Calculate(Sum('On Order'[REMAINPURCHPHYSICAL]),FILTER('On Order','On Order'[REMAINPURCHPHYSICAL]>0 && 'On Order'[REQUESTDELIVERYDATE] >= Today()))

Please mark it as answer if it solves your issue. Kudos are also appreciated.

Cheers,

Shishir.