TOTALMTD showing values that should not be inscope.

[astano05]

I have this measure that shows data and the total is correct, but is bringing in data that is not inscope.

Quote Count MTD = TOTALMTD([Quote Count],Headers[Effective Date])

Result:

the total 277 is correct but the 1 values at the top and bottom are not actually inscope. 

when filtering for June 2024 the results are correct:

How can I edit the dax to only show the data inscope. When no month is selected i want it to default to current month. When past months are selected I want it to show the past month's data, which is currently working as expected. Issues are with current month. What is causing this?

[Greg_Deckler · Accepted solution]

@astano05 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...