MTD, PYTD
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
