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.