How to efface blank category row without affecting TOTAL
I have created a calculated column with DATESINPERIOD to always show the last 7 days of my report and connected it to my 'Dates' table. When I apply the measure to the new table, I get a top row with a blank category but with a large number. So I use HASONEVALUE to eliminate the top row but I end up eliminating the Total as well.
Is there another way to do it without affecting the Total?