Subtracting acumulated sum per date does not work in existing report (but in test report)

[dEllE]

Hello folks,
I have the following problem and am about to give up 😞

A source table contains the forecast quantity per day and article.

I calculate the cumulative total of the forecast quantity per day and article with the following measure:

Sales plan Qty by day cummulated Msr =

CALCULATE(

    'Sales plan by day'[Sales plan Qty by day Msr],

        FILTER(ALLSELECTED('DAX-Calendar'[Date]),

            'DAX-Calendar'[Date] >= TODAY() &&

            'DAX-Calendar'[Date] <= MAX('DAX-Calendar'[Date]

            )

        )

)

Another table contains the current inventory per item.

Now I calculate the reach per day and article using the following measure:

Remaining Qty Msr =

SUM('Item stock to date'[Stock_qty]) - [Sales plan Qty by day cummulated Msr]

This works in my test report, which only contains the required tables.

Unfortunately it doesn't work with the same measures in my existing report and I can't find the error.

When the day of subtracting the accumulated sum starts, the stock quantity is gone!

I checked all the table relationships in the model view. Everything looks correct to me.

Maybe one of you can see where the error could be.

Working report and model view:

 

NOT working report and model view:

 

I hope you can see everything in the pictures.

If there are any further questions, please just ask.

Hope I finally get this problem solved.

Thanks in advance.

Greetings dEllE

[dEllE · Accepted solution]

@Greg_Deckler .

There were no visual, page or report filters, BUT for whatever reason I made the relation between "item" and "sales invoices" bidrectional. This was causing problems with the dates relation between "sales plan" and "stock to date".

So thx for the idea with filtering.

[Greg_Deckler]

@dEllE Long shot but perhaps the removal of the leading zeros from the ? item number ? broke something in the relationships in the model? Otherwise, check the filters on the page and make sure that some other table isn't filtering your Item table and causing issues.