Convert a Calculated table to a Dynamic table

[sahar_nezhad]

Hi ALL, I have created a dynamic table with following DAX, I need to create it in a way that can be sliced by a slicer which defines SelectedProject instead of defining it manually :

FinOpsProgressTimeline =

VAR SelectedProject = "FinOps"

VAR StartDate =

    CALCULATE(

        MIN('tr_projects'[tr_plannedstartdate]),

        'tr_projects'[tr_nickname] = SelectedProject

    )

VAR EndDate =

    CALCULATE(

        MAX('tr_projects'[tr_plannedfinishdate]),

        'tr_projects'[tr_nickname] = SelectedProject

    )

RETURN

ADDCOLUMNS (

    CALENDAR(StartDate, EndDate),

    "PlannedProgress%",

    VAR CurrentDate = [Date]

    RETURN

    SUMX (

        FILTER(

            'tr_highlevelwbses',

            RELATED('tr_projects'[tr_nickname]) = SelectedProject

        ),

        VAR TaskStart = 'tr_highlevelwbses'[tr_plannedstartdate]

        VAR TaskEnd = 'tr_highlevelwbses'[tr_plannedfinishdate]

        VAR Duration = DATEDIFF(TaskStart, TaskEnd, DAY) + 1

        VAR Elapsed = DATEDIFF(TaskStart, MIN(CurrentDate, TaskEnd), DAY) + 1

        VAR Progress =

            SWITCH (

                TRUE(),

                CurrentDate < TaskStart, 0,

                CurrentDate > TaskEnd, 1,

                TRUE(), Elapsed / Duration

            )

        RETURN Progress * 'tr_highlevelwbses'[tr_weightfactor]

    ),

        "ActualProgress%",

    CALCULATE(

        MAX('tr_projecthistoricaltrends'[tr_actualprogress]),  

        FILTER(

            'tr_projecthistoricaltrends',

            RELATED('tr_projects'[tr_nickname]) = SelectedProject &&

            'tr_projecthistoricaltrends'[tr_date] = [Date]

        )

    )

)

[v-achippa]

Hi @sahar_nezhad,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @danextian and @burakkaragoz for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @sahar_nezhad,

We wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @sahar_nezhad,

We wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[danextian]

Hi @sahar_nezhad 

Calculated tables and columns are not aware of slicer selections so they won't update as you interact with a slicer. You will need to use a table (visual) with all the needed columns and use a measure to control what rows will be visible.

[burakkaragoz · Accepted solution]

Hi @sahar_nezhad ,

To make your calculated table respond to a slicer selection, you’ll need to switch from a calculated table to a measure-based visual or use a calculated table inside a visual (like a matrix). Calculated tables are static at model load time and don’t respond to slicers.

Here’s what you can do instead:

Option 1: Use a Parameter Table + Measures

1. Create a separate table with project names (if not already available).
2. Use a slicer on that table.
3. Replace VAR SelectedProject = "FinOps" with:

VAR SelectedProject = SELECTEDVALUE('Projects'[tr_nickname])

But again, this won’t work inside a calculated table. You’ll need to move the logic into a measure and use it in a visual like a matrix or line chart.

Option 2: Use a Paginated Report or Calculation Group

If you absolutely need a dynamic table output, consider using a paginated report or a calculation group to simulate dynamic table behavior.

Here’s a Microsoft doc that explains why calculated tables don’t respond to slicers:\ Microsoft Learn

Let me know if you want help converting your logic into a measure-based visual.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

Translation and formatting supported by AI