Forum Discussion
Show missing values as 0 on Matrix table
Hi aneedleman
Whether yo use +0 or COALESCE, the measure will not return 0 for rows that don't exist. For example, if you're the columns from your fact table and there is no such row for Jan 2025 + Savings Secured C/E in that table, you cannot assign a 0 value to that.
The images below use the same measure but the first one uses the columns from the fact table wherein some combinations of those don't exist
The second one uses column from the different dimensions table
Please note that forcing a measure to return zero when blank can return unexpected results and may cause a performance issue that is very noticeable on large tables. https://data-mozart.com/why-you-should-not-replace-blanks-with-0-in-power-bi/
Please see the attached sample pbix.
Super UserHi aneedleman
Whether yo use +0 or COALESCE, the measure will not return 0 for rows that don't exist. For example, if you're the columns from your fact table and there is no such row for Jan 2025 + Savings Secured C/E in that table, you cannot assign a 0 value to that.
The images below use the same measure but the first one uses the columns from the fact table wherein some combinations of those don't exist
The second one uses column from the different dimensions table
Please note that forcing a measure to return zero when blank can return unexpected results and may cause a performance issue that is very noticeable on large tables. https://data-mozart.com/why-you-should-not-replace-blanks-with-0-in-power-bi/
Please see the attached sample pbix.
Hi Dane,
I really appreciate your help. I don't see any attached PBIX files, could you please attach it or paste the raw DAX you used for it? Your solution seems like exactly what I'd need. Thank you!