Forum Discussion
Help with filtering table and using that table as context
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
)
)
You need to pack the entire logic into a new measure.
SELECTEDVALUE() means nothing when creating a calculated table. It can only ever be used with measures.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
This is a real sample of the data:
| 1 | 10/1/2025 | True |
| 2 | 10/10/2025 | False |
| 2 | 10/10/2025 | True |
| 3 | 10/11/2025 | True |
| 4 | 10/12/2025 | True |
After we filter out the 'False' entries I expect the following table:
| 1 | 10/1/2025 | True |
| 2 | 10/10/2025 | True |
| 3 | 10/11/2025 | True |
| 4 | 10/12/2025 | True |
Then after applying the date accumulation (based on dates after 10/9/2025) I expect the following table (with a newly added column):
| 1 | 10/1/2025 | True | 0 |
| 2 | 10/10/2025 | True | 1 |
| 3 | 10/11/2025 | True | 2 |
| 4 | 10/12/2025 | True | 3 |
Keep in mind, that last generated column is based on the filtered table. The value calculated there is equivalent to saying something like: "count all dates prior to this date but after 10/9/2025".
Hi,
PBI file attached.
Hope this helps.
