Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost 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 I...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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
    Icon for Post Prodigy rankPost 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?