Total YTD and USERELATIONSHIP to calculate revenue only for terminated clients

[Claudine_Ma]

Unfortunately my initial post has been marked as a spam. 

Can somebody help me anyhow? Total YTD with USERELATIONSHIP - Microsoft Fabric Community 

[bhanu_gautam · Accepted solution]

@Claudine_Ma , Try using

Revenue YTD Terminated Clients =
CALCULATE(
[Revenue YTD],
dim_clients[Termination] = "Yes",
USERELATIONSHIP(dim_Date[Date], dim_clients[Termination Date]),
FILTER(
dim_clients,
dim_clients[Termination Date] <= MAX(dim_Date[Date])
)
)

[Claudine_Ma]

Thanks for answering. Somehow the other ones got removed from Spam so I got an answer there. I didn´t test yours - but it is very similiar so I´ll mark it as a solution.