Forum Discussion
Solved
Help with filtering table and using that table as context
I realize that my subject is a bit vague so let me start with a practical example. I have the following data: 1 10/1/2025 2 10/10/2025 3 10/11/2025 4 10/12/2025 and I want to ...
Create a calculated column:
Burndown Count =
VAR CurrentDate = 'table'[Changed Date]
VAR FilteredTable = FILTER(ALL('table'), 'table'[Is Current] = TRUE())
RETURN
COUNTROWS(
FILTER(
FilteredTable,
'table'[Changed Date] >= DATE(2025, 10, 9) &&
'table'[Changed Date] <= CurrentDate
)
)
Create a calculated column:
Burndown Count =
VAR CurrentDate = 'table'[Changed Date]
VAR FilteredTable = FILTER(ALL('table'), 'table'[Is Current] = TRUE())
RETURN
COUNTROWS(
FILTER(
FilteredTable,
'table'[Changed Date] >= DATE(2025, 10, 9) &&
'table'[Changed Date] <= CurrentDate
)
)
VAR CurrentDate = 'table'[Changed Date]
VAR FilteredTable = FILTER(ALL('table'), 'table'[Is Current] = TRUE())
RETURN
COUNTROWS(
FILTER(
FilteredTable,
'table'[Changed Date] >= DATE(2025, 10, 9) &&
'table'[Changed Date] <= CurrentDate
)
)
This is exactly what I was looking for! I believe the thing I was missing was how to convey the row value of a filtered table as context for the inner-filter. Making a column filter based on the computed table was the missing piece. Thank you!