Forum Discussion
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
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.
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.
Many thanks for your reply.
I used your measure but with average + 0, worked perfectly.