- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

DAX to return seperate values for 0 and BLANK
Helllo guys,
Is there any way for me to tell DAX to distinguish between BLANK and 0. If I run BLANK() DAX converts all cells with blank to 0 and BLANK() returns true for both 0 and blank.
e.g.
My raw data is following
CAT | Value |
A1 | |
A2 | 0 |
A3 | 0 |
A4 | 100 |
A5 | 100 |
A6 | 1 |
A7 |
Currently it returns
CAT | Value | Current Result |
A1 | blank | |
A2 | 0 | blank |
A3 | 0 | blank |
A4 | 100 | non-blank |
A5 | 100 | non-blank |
A6 | 1 | non-blank |
A7 | blank |
Is there any way for me to tell DAX to return the following as my desired result
CAT | Value | Desired result |
A1 | blank | |
A2 | 0 | non-blank |
A3 | 0 | non-blank |
A4 | 100 | non-blank |
A5 | 100 | non-blank |
A6 | 1 | non-blank |
A7 | blank |
I tried with both
and
but I could not make DAX to return what I wanted.
The sample PBIX is attached. if someone can please help would be great.
Thank you in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HI @smpa01 ,
Please check if the below video can be of any help.
https://www.youtube.com/watch?v=C26DQkb4hyY
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@amitchandak thanks it worked
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HI @smpa01 ,
Please check if the below video can be of any help.
https://www.youtube.com/watch?v=C26DQkb4hyY
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@harshnathani thanks mate, it worked. == did the trick.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-04-2024 10:37 PM | |||
10-19-2020 04:14 AM | |||
05-17-2024 04:33 AM | |||
07-29-2024 01:16 AM | |||
Anonymous
| 05-05-2019 11:48 PM |
User | Count |
---|---|
128 | |
121 | |
85 | |
59 | |
47 |