Forum Discussion
Summarize Filtered by date slicer
I would like to filter a summarized table with a date slicer, I have tried with a connect with a date table and also with a date field in the orginal table:
SummarizedTable =
SUMMARIZE(
FILTER(
ALL('Daily at a Glance'),
'Daily at a Glance'[Date] >= MIN('Daily at a Glance'[Date]) &&
'Daily at a Glance'[Date] <= MAX('Daily at a Glance'[Date])
),
'Daily at a Glance'[Row], -- Grouping by the Row (index) column
"Total Current Year", CALCULATE(SUM('Daily at a Glance'[Current Year])),
"Total Prior Year", CALCULATE(SUM('Daily at a Glance'[Prior Year]))
)
OldCorps41 , A calculated Table and Calculated Column can not use slicer values. so please try use this in a measure
3 Replies
- amitchandak
Super User
OldCorps41 , A calculated Table and Calculated Column can not use slicer values. so please try use this in a measure
- OldCorps41New Member
Thank you for the quick reply - would I use the same formula but in DAX?
- OldCorps41New Member
I made it a measure and it worked correctly - thank you.