Filter one Column for a Specific Date and other Columns to run off date slicer

[earltom]

Hi

2 Tables - FACT  and Master Data (State Field) with City to City mapping

Date Slicer

I want Col 1 one to run off date slcier and Col2 to run for a specific date, I tried using Calcualte(Sum(Sales), Filter(FACT, Date ="2021") but when I click on 2022 it goes blank for Col2  

	Col1	Col2
NY	5	3
CAL	6	6
NC	7	7

[amitchandak · Accepted solution]

@earltom , you need to use date table for that joined with your table

Calcualte(Sum(Sales), Filter(all(Date), Date[Date] ="2021")