Calculated table that responds to context

Hello nicoenz,
Thank you for reaching out to the Microsoft Fabric Forum Community. I have reproduced your scenario in Power BI Desktop as you described.

Summary of What I Did:

• I created a disconnected axis table with GENERATESERIES for the X-axis values (0 to 10 million).
• I replaced the calculated table approach with measures that calculate FMC, VMC, and NS dynamically using SELECTEDVALUE from the axis table.
• I built a line chart using this axis table on the X-axis and the measures on the Y-axis.
• I tested with slicers filtering the Product field, and the chart values update dynamically as expected.

This approach meets your requirement to have a fixed number of rows (axis values) that respond to slicer/filter context.

For your reference, I am attaching the .pbix file demonstrating this solution so you can explore or adapt it further.

Thank you, Greg_Deckler for sharing valuable insights.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.