Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
IeuanG
Frequent Visitor

Show blank as 0 in the matrix

For reason when I'm creating a matrix it's not returning 0 where there is blanks.  Can someone help me withis?

 

All the relevant info is below;

 

The DAX to calculate the value is 

Value = SUM('DemoP&LData'[TransactionValue]) + 0
 
IeuanG_1-1688391650510.pngIeuanG_2-1688391686951.png

 

Thanks

 

2 ACCEPTED SOLUTIONS
Jihwan_Kim
Super User
Super User

Hi,

In my opinion, if you create dimension tables for Code and Department, and then put those into the visualization, -> then the measure with +0 will work to show 0 when the result is blank.
Thanks.


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

Greg_Deckler
Community Champion
Community Champion

@IeuanG You're likely running into AutoExist but hard to be 100% sure given the information. If you are, then the formula isn't even evaluated for combinations that AutoExist removes.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
IeuanG
Frequent Visitor

@Jihwan_Kim Thank you this worked! 

Greg_Deckler
Community Champion
Community Champion

@IeuanG You're likely running into AutoExist but hard to be 100% sure given the information. If you are, then the formula isn't even evaluated for combinations that AutoExist removes.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

I haven't come across AutoExist before or even knew it was a thing so I've got some reading to do! @Greg_Deckler 

Jihwan_Kim
Super User
Super User

Hi,

In my opinion, if you create dimension tables for Code and Department, and then put those into the visualization, -> then the measure with +0 will work to show 0 when the result is blank.
Thanks.


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.