Replacing null with zero brings extra rows to the matrix
I have a requirement to replace null with zero inside the matrix. I have two metrics and two dimensions and the data is at the monthly level. I have already replaced null with zero in the Power Query, but as seen below the values still appear as null. I have been trying a few approaches recommended in the Community: - Adding +0 to the measure - Use if(isblank(measure), 0, measure) - Use COALESCE(measure, 0) Each of those techniques replaces nulls with zeros, however, this is being done for all the values in the database. It is resulting in bringing many extra rows to my matrix along with very poor performance. Example below: Is there any way to inject "0" in my matrix without bringing extra rows?How to replace empty cells in matrix with another value?
Grettings, I'm trying to fill this empty cells on this table with the value "100%". I've already applied "ISBLANK" and "+0" at the end of the formula. Is there any other way to fill these cells? The values "%" showed are a calcutated column of two measures.
