Calculated Table creating blank rows in matrix

Hi wiranqa,

Thank you for your inquiry through the Microsoft Fabric Community Forum.

Based on my understanding, the blank rows are occurring because the calculated table, YOY NPS, includes both actual data (month-year combinations) and virtual rows (such as 2024 NPS, 2025 NPS, etc.). These virtual rows do not exist in your fact table, which is why measures like [Sales Only] return blank results when there is no corresponding filter context.

Please follow the steps below to help resolve the issue:

1. Maintain the YOY NPS table as disconnected (without any relationships to your sales data table). This is by design and ensures that it functions effectively as a dynamic column driver in your matrix.
2. Create your base measure (for example, Total NPS) directly in the Sold To Unpivot table, as this is your primary fact/data table and the appropriate location for aggregations.
3. All helper and dynamic measures (such as totals for 2024/2025, differences, and percentage changes) should be developed within the YOY NPS table, as they depend on its column structure and logic.
4. In your matrix visual, utilize YOY NPS[Measure] as the column, and use Parent, Customer, and Product as rows while employing your dynamic measure (e.g., AllMeasures) as the value.
5. No physical relationship is required between YOY NPS and Sold To Unpivot. DAX measures utilizing logical filtering will manage the necessary context.
6. Ensure that the column order in the matrix is sorted by a numeric index within the YOY NPS table to align with the desired output.

If you find this response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members who may have similar queries.

Thank you.