- 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

Equivalent of tableau Function: Lookup and ZN
Dear all,
I am using the following tableau formula:
zn(LOOKUP(SUM([Backlog]),0))
I need to convert this formula in power bi.
Thanks in advance for help
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

https://www.sqlbi.com/articles/how-to-return-0-instead-of-blank-in-dax/ (if below wont work)
Sol= IF ( CALCULATE ( SUM ( Backlog) ) = BLANK (), 0, CALCULATE ( SUM ( Backlog) ) )
Regards,
Ritesh
Since I have experience with Tableau, I suppose neither technique will necessarily work. In essence, there is a difference between BLANK and Nothing, therefore utilising the LOOKUP function is necessary because there is nothing there.
I see this option for that one,
https://devoworx.net/how-to-show-zero-values-in-power-bi-chart/
Watch my Linkedin Post Post | Feed | LinkedIn
BEFORE
STEP 1
You need to create a separate table for Ship Mode
STEP 2
STEP 3
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Please mark the answer and help the community in return, if it did not help please let us know
Regards,
Ritesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi Ribisht,
I am facing an issue after applying below mentioned formula in powerbi. In PowerBI if we set the value as current week and for tableau if we set value as previous week, then required numbers are matching. But when setting both Tableau and PowerBi to point to the current week, numbers are not matching. Can you please suggest what could be the possible issue?
Thanks and Regards
Shantanuj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi Ribisht,
Currently, implementing other aspects as well. Once completed if it works, will mark this as a solution. And if it doesn't work will let you know.
Thanks and Regards
Shantanuj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Not a problem, you can watch my video on the same topic as well
PL 300 Series Use Case -Null to Zero (DAX) - YouTube
Regards,
Ritesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

https://www.sqlbi.com/articles/how-to-return-0-instead-of-blank-in-dax/ (if below wont work)
Sol= IF ( CALCULATE ( SUM ( Backlog) ) = BLANK (), 0, CALCULATE ( SUM ( Backlog) ) )
Regards,
Ritesh
Since I have experience with Tableau, I suppose neither technique will necessarily work. In essence, there is a difference between BLANK and Nothing, therefore utilising the LOOKUP function is necessary because there is nothing there.
I see this option for that one,
https://devoworx.net/how-to-show-zero-values-in-power-bi-chart/
Watch my Linkedin Post Post | Feed | LinkedIn
BEFORE
STEP 1
You need to create a separate table for Ship Mode
STEP 2
STEP 3
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Shantanuj
Could you please attach a sample PBIX file/table that can be copied (no screenshot) and your desired results?
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-30-2020 07:57 AM | |||
05-21-2023 08:39 AM | |||
Anonymous
| 10-05-2024 12:02 AM | ||
03-12-2024 06:43 AM | |||
09-28-2021 11:33 PM |
User | Count |
---|---|
90 | |
82 | |
57 | |
41 | |
39 |