Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Table Matrix blank

Hi,

 

Is there  a way I can get the a table matrix row to display as 0 when blank, when it comes from SQL and is not a measure?

 

Thanks

 

Liam

Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    Here are a few suggestions:

     

    SQL: 

    SELECT

      ISNULL(Value, 0) AS Value

    ...

     

    Measure:

     

    Measure = SUM(Table[Value])+0

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

3 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,

     

    Here are a few suggestions:

     

    SQL: 

    SELECT

      ISNULL(Value, 0) AS Value

    ...

     

    Measure:

     

    Measure = SUM(Table[Value])+0

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Many thanks for your reply.

       

      I used your measure but with average + 0, worked perfectly.

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    As mwegener's suggestion, you can create measure like DAX "Measure = SUM(Table[Value])+0 ", you can also create measure like DAX below.

     

    MEASURE = IF ( ISBLANK ( SUM ( 'Table'[Sales] ) ), 0, SUM ( 'Table'[Sales] ) )

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.