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.

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.