I have a problem that showing Lifetime amount by using ALL() or REMOVEFILTERS() functions on my report.
I have created a new date table as slicer that implies Yesterday, Last 7 Days, Same Day Last Month, All, Custom etc., and it works perfect. But when I selected any slicer rather than "All", Lifetime Revenue does not show correct amount.
Since the new slicer table consists duplicate dates, the cross-filter direction on relationship is not single as below.
The dax query, I've used is to get Life Time Revenue:
Revenue_Lifetime =
CALCULATE(
SUM(Revenue[Revenue]),
ALL('Date Periods'[Date],'Date Periods'[Type])
)
Here is a sample report that shows the problem:
Thank you,
Kisa