Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Sign in

How to return BLANK instead of zero

SQLBI

SQLBI

120K subscribers

Subscribe

Subscribed

238

Share

Save

12K views 3 years ago

12,957 views • Mar 15, 2022

How to return BLANK instead of zero in a DAX measure: Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero. Article and download: https://sql.bi/745368?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... ...more

...more

Comments 19

Top comments

Newest first

Key moments

Demo

0:41

Multiplication by the Result of a Divide Operation

4:20

Advantages

9:44

Sync to video time

Description

How to return BLANK instead of zero

238Likes

12,957Views

2022Mar 15

How to return BLANK instead of zero in a DAX measure: Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero. Article and download: https://sql.bi/745368?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Key moments

View all

Demo

0:41

Multiplication by the Result of a Divide Operation

4:20

Advantages

9:44

Transcript

Follow along using the transcript.

Show transcript

SQLBI

120K subscribers

Videos

About

Marco Russo on Twitter

Alberto Ferrari on Twitter

LinkedIn

Facebook

Transcript

Using ALLEXCEPT vs ALL VALUES

SQLBI

SQLBI

•

61K views 3 years ago

Show blank as zero - Unplugged #20

SQLBI

SQLBI

•

9.6K views 4 years ago