Forum Discussion

wcloninger's avatar
wcloninger
Icon for Helper I rankHelper I
3 years ago

Default value for a value in a matrix

I have a matrix table that shows the average uptime of a help desk ticket to be resolved. I have the product names for the rows and years/months for the columns for the date the problem occurred. The values are the average uptime for each product. All is good, but....Some months didn't have a ticket called in. So, the cell is blank, in which the cell should be 100%. I need the cells that have no tickets called in to have the value 100. Is this possible? 

Need Help

11 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi,

     

    yeah, you should be able to wrap your current percentage in an if statement:

     

    e.g if(isblank(Average Field or Calculation),100,Average Field or Calculation)

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


     

    • wcloninger's avatar
      wcloninger
      Icon for Helper I rankHelper I
      3 years ago

      Thank you for the response, but i'm still getting white cells. How does it know to add anything for the november month under the product finance if no events happened in november for Finance?

      • DOLEARY85's avatar
        DOLEARY85
        Icon for Resident Rockstar rankResident Rockstar
        3 years ago

        I'd need to know more about the data and actual measure to see what's going on.

         

        Are you able to share the PBIX file?