The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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.
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Many thanks for your reply.
I used your measure but with average + 0, worked perfectly.
User | Count |
---|---|
109 | |
82 | |
74 | |
53 | |
49 |
User | Count |
---|---|
133 | |
97 | |
94 | |
71 | |
70 |