Hide row generated from visual calculations in matrix visual

Kalin_Iliev 

Option 1: Use a Visual-Level Filter

If the blank row has a total but no monthly values, you can filter it out by checking for blanks in one of the month columns:

1. Select the matrix visual.
2. In the Filters pane, add a filter on a representative measure (e.g., Demand for January).
3. Set the filter to “is not blank” or “greater than 0”.

This hides rows where that measure is blank or zero.

Option 2: Adjust the DAX Measure

Modify your measure to return BLANK() when the row shouldn't be shown. For example:

Demand Comparison = IF( HASONEVALUE('Date'[Month]) && [YourLogicHere], [Demand], BLANK() )

Then use the same visual-level filter to exclude blank values.

 Option 3: Use a Calculated Column or Table Filter

If the row is coming from a calculated table or column, you can pre-filter it:

FilteredTable = FILTER( OriginalTable, NOT(ISBLANK([Demand])) )

Use this filtered table in your matrix visual instead.

Option 4: Hide Totals for Blank Rows (Advanced)

If the row only shows a total and no monthly values, you can suppress the total using DAX:

Demand Comparison = IF( COUNTROWS(VALUES('Date'[Month])) = 0, BLANK(), [Demand] )

This prevents the total from showing unless there are monthly values.