Forum Discussion
Solved
Total YTD with USERELATIONSHIP
Hey all, I struggle with some DAX and would appreciate a little help as I can´t seem to figure this one out. So I have a client table (Dimension Table) where some clients have terminated th...
How can I write a DAX measure where the date slice affects both the revenue YTD (revenue only for the selected timeframe) and the termination date (only clients terminated in the selected time range)?No need for the inactive relationship. Add a filter to your calculation
Revenue YTD = CALCULATE(TOTALYTD(SUM(Revenue),Dim_Date[Date]),Client[Termination Date] in VALUES(Dim_Date[Date]))
lbendlin
Super User
Super UserHow can I write a DAX measure where the date slice affects both the revenue YTD (revenue only for the selected timeframe) and the termination date (only clients terminated in the selected time range)? No need for the inactive relationship. Add a filter to your calculation
Revenue YTD = CALCULATE(TOTALYTD(SUM(Revenue),Dim_Date[Date]),Client[Termination Date] in VALUES(Dim_Date[Date]))
Thanks so much. This works ! 😊