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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dkoek
New Member

Hiding zero's on running total

Hello,

 

I made a DAX Measure with a running total like in the picture.

When a value is 0, it can mean that there is an underlying value  of f.e. +64 and -64 which is 0 in total.

I tried to use the filter pane to hide the zero values but I am unfortunate.

What am I doing wrong ?

dkoek_0-1663796615426.png

dkoek_1-1663796738432.png

 

1 REPLY 1
Greg_Deckler
Super User
Super User

@dkoek Have your measure return BLANK if ROUND of your calculation ends up 0.


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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