Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
3 years ago

Zero in Matrix Tables

I use the following for Values in a Matrix Table.  

 

Count of Total Gross Incurred No Row = IF(ISBLANK(CALCULATE(COUNT(LossRunToExcel[Total Gross Incurred]))),0,COUNT(LossRunToExcel[Total Gross Incurred]))
 
It takes care of placing a zero in most cells but not all, I still end up with some cells that are blank?
 
What do I need to add to make all blank cells show a zero?   
Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    bdehning Try: 

    Count of Total Gross Incurred No Row = IF(ISBLANK(CALCULATE(COUNT(LossRunToExcel[Total Gross Incurred]))),0,COUNT(LossRunToExcel[Total Gross Incurred]))+0
    • bdehning's avatar
      bdehning
      Post Prodigy
      3 years ago

      It is so strange but I am left with one blank under 03/01/2019, even with what you sent.   Confused?