Convert a Calculated table to a Dynamic table

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