I am trying to calculate the difference between the Overall Count (Lifetime of the data) of Seller ID's and the count of Seller Id's when date = Today. I tried using something like this for Current Count calculation (If Date = Today() then Seller ID's) then I created a calculation that said (Seller ID's - Current) to calculate the difference between the two. This works properly when my date slider is showing all time, however when I move the dates back at all, the current is technically no longer 'Today' and the calculation does not work. Can anyone assist on this?
Thanks!
So, instead of current being today's date, do you want it to actually be the last date in your selection? If so, then you can change Seller ID (Current) to use an LOD as follows:
If [Date] = {FIXED : MAX([Date])} THEN [Seller ID (Overall)] END
Then right-click on the Date filter and select "Add to Context" so that the filter is applied before the LOD is calculated.
The result will look like this. See the attached workbook.
