TOTALMTD showing values that should not be inscope.

astano05 — Mon, 17 Jun 2024 16:10:14 GMT

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?

Re: TOTALMTD showing values that should not be inscope.

Greg_Deckler — Mon, 17 Jun 2024 16:41:55 GMT

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-TITHW/m-p/434008

topic TOTALMTD showing values that should not be inscope. in DAX Commands and Tips

TOTALMTD showing values that should not be inscope.

Re: TOTALMTD showing values that should not be inscope.