Hide Blank Rows not whole result

Hi kpct56591,
Coud you please try below measures 

1. Create new "MetricsName" table using "Enter Data" options.
   
2. Create measures like "Case Spend" and "Total Case Spend" if not created 
3. Create a new measure like below 

Matrix Value = 
SWITCH(
    SELECTEDVALUE(MetricsName[Metric Name]),
    "Ship Qty", SUM('Sales_Data'[Ship Qty]),
    "Gross Sales", SUM('Sales_Data'[Gross Sales]),
    "Case Spend", 
        VAR v = SUM('Sales_Data'[Case Spend])
        RETURN IF(ISBLANK(v), BLANK(), v),
    "Total Case Spend", 
        VAR t = [Total Case Spend]
        RETURN IF(ISBLANK(t), BLANK(), t)
)​

3. Add the fileds as shown below and switch values to rows. Then uncheck the "Show items with no data".   

Using above steps you will get required results.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.