Forum Discussion
Microsoft EmployeeHelp 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
)
)
Super UserYou 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
CADACAMAThis 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".- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.
