Forum Discussion
Solved
Using a calculated date to filter all visuals and measures on a page.
I have 2 measures which each provide a specific, singular date, used together to provide a period start and end date. What I want to do is be able to filter all of my data on my fact table (which ...
JayhawkDylan , Create a measure like
Sumx(Table, Calculate(Sum(Table[Value]), filter(Table, Table[Date] >= [Start Date] && Table[Date] <= [End Date]) ) )
JayhawkDylan , Create a measure like
Sumx(Table, Calculate(Sum(Table[Value]), filter(Table, Table[Date] >= [Start Date] && Table[Date] <= [End Date]) ) )
I think this gets very close to what I need if I remove the sumx, close enough I can figure out how to adjust the specifics measures I am working with from here. Thanks!
Calculate(Sum(Table[Value]), filter(Table, Table[Date] >= [Start Date] && Table[Date] <= [End Date]) )