Table Matrix blank

[Anonymous]

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

[v-xicai]

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.

[mwegener · Accepted solution]

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]

Many thanks for your reply.

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