Reply
Topic Options
- 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
Changing blank to 0
06-09-2023
05:35 AM
Hello,
I have a matrix in my Power Bi report that shows Sales Orders by year. However, some products have no sales in some months and the DAX I currently use returns blanks instead 0.
I need the DAX to return 0 instead of blank. My current DAX is COUNTROWS(SalesOrders)
Can anyone help?
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
06:52 AM
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-21-2022 07:08 AM | |||
05-16-2018 04:51 AM | |||
01-28-2025 08:03 AM | |||
01-24-2025 12:57 AM | |||
02-27-2025 01:37 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |