MTD, PYTD

[TechPain]

I have a report where i've calucalated the MTD, Total, etc

MTDCases =
Var MTD_Cases=TOTALMTD([T_Cases],'Date'[Date], FILTER('Date','Date'[Date]<=TODAY()))
Return
IF(ISBLANK(MTD_Cases),0,MTD_Cases)

T_Cases =

Var TotalCases = CALCULATE(DISTINCTCOUNT('Cases_Details'[Casenum]))
Return
TotalCases

when I use MTD, PYTD on the report it is including services that is not associated with the type of report selected.

is there anyway to exclude the services from displaying?

casenum	date	services
1235	03/01/2023	cardiac
8885	03/03/2023	pediatric
7569	03/01/2023	thoracic
9955	03/04/2023	ENT

[Greg_Deckler]

@TechPain 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...