Forum Discussion

CADACAMA's avatar
CADACAMA
Microsoft Employee
9 months ago
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 ...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    9 months ago

     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
    )
    )
     
     

    CADACAMA

Kedar_Pande's avatar
Kedar_Pande
Super User
9 months ago

 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
)
)
 
 

CADACAMA

  • CADACAMA's avatar
    CADACAMA
    Microsoft Employee
    9 months ago

    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!