Forum Discussion
Solved
Total Sales calculation based on a dynamic flag that updates based on SELECTEDVALUE() date slicer.
Hi everyone! I have a measure that calculates total sales using SUM function [Total Net Sales]. I am currently using calculation groups for Time Intelligence which are working perfectly fine. The ...
UPDATE:
Was able to get the measure to work:
Net Sales := CALCULATE ( [Total Net Sales], FILTER ( 'FactSales', 'FactSales'[Date abc] <= SELECTEDVALUE('Date'[Week ending date]) ) )
UPDATE:
Was able to get the measure to work:
Net Sales :=
CALCULATE (
[Total Net Sales],
FILTER (
'FactSales',
'FactSales'[Date abc] <= SELECTEDVALUE('Date'[Week ending date])
)
)