Slicer being ignored on filter

[MartySapp]

Hi,

i have the following code

Working Capital user date = VAR NetSales = CALCULATE([Running Total all time], all(Header),Header[Header] ="Revenue",  all('2022&2023'),'2022&2023'[Period Lookup.StartDate] > SELECTEDVALUE('2022&2023'[Period Lookup.StartDate]) && '2022&2023'[Period Lookup.StartDate] < DATE (2023,01,01)) --End Date

    VAR TotalWC = CALCULATE([Magic Additive Total bs -Ratios]/1000)

    VAR Result = DIVIDE(TotalWC  , NetSales)

    return Netsales

the start date is picked from the slicer but the All filter on the calc is ignoreing it, if i manualy code the dates in like below then i get the result i want , any ideas?

Working Capital = VAR NetSales = CALCULATE([Running Total all time], all(Header),Header[Header] ="Revenue", all('2022&2023'),'2022&2023'[Period Lookup.StartDate] > DATE(2022,02,01) && '2022&2023'[Period Lookup.StartDate] < DATE(2023,03,01))

    VAR TotalWC = CALCULATE([Magic Additive Total bs -Ratios]/1000)

    VAR Result = DIVIDE(TotalWC  , NetSales)

    return Netsales

[amitchandak]

@MartySapp , all('2022&2023') is causing that , You should use date table in such cases

refer these examples

CALCULATE([Running Total all time], all(Header),Header[Header] ="Revenue", filter(2022&2023','2022&2023'[Period Lookup.StartDate] > Max('Date'[Date]) && '2022&2023'[Period Lookup.StartDate] < DATE (2023,01,01)))

Here date table can be an independent date table

https://youtu.be/UoDPMF0nh3Q

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[MartySapp]

@amitchandak

Thanks i thought "all" would be causing problems.

i have a spereate "Calander" Table with a Date , now im getting Blank as answer regradless of what date i pick as start date for the range 

VAR NetSales = CALCULATE([Running Total all time], all(Header),Header[Header] ="Revenue",  Filter('2022&2023','2022&2023'[Period Lookup.StartDate] > MAX ('Calendar'[Date]) && '2022&2023'[Period Lookup.StartDate] < DATE (2023,01,01)))

    VAR TotalWC = CALCULATE([Magic Additive Total bs -Ratios]/1000)

    VAR Result = DIVIDE(TotalWC  , NetSales)

    return Netsales