Filter results on timetable

[Datendialog]

Dear Community,

I have an ordertable with order-ID and order time and a timetable, where the column current week offset defines, if I am in the current mont(0), in the last (-1) or any other previous month(-x).

Now I tried to figure out the number or orders for the current month with the following formula:

orders current month =
CALCULATE(
count(order[id]), FILTER(Timetable, Timetable[CurMonthOffset] = 0))

There is no syntax error but the result doesn´t match with my data.

Where did I go wrong?

Thanks for your advice.

[daxer-almighty]

Not enough info to troubleshoot.

How to Get Your Question Answered Quickly - Microsoft Power BI Community