- 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

Pivot file count error when nulls present
I am a newbie to PBI. I do use Tableau.
I use the following calculation to count the number of xyz records in xyz_total that have a score = or > 38. I use Distinctcount on the Record id because the file is pivoted (Record Id is a unique identifier)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @MalcolmR,
You can use the BLANK() function in DAX along with the operator "==" which is strictly blank, which will ignore the 0s in your column and count the blanks.
You can use it in the another measure changing the condition in the filter argument of calculate.
Here is a link explaining the BLANK() function.
Hope this helps.
Thank you,
Vishesh Jain
If yes, then please mark my post as a solution!
Thank you,
Vishesh Jain
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @MalcolmR,
You can use the BLANK() os ISBLANK() functions in DAX, this will igore the 0s in your column and count the blanks.
You can use it in the another measure changing the condition in the filter argument of calculate.
Here is a link explaining the BLANK() function.
Hope this helps.
Thank you,
Vishesh Jain
If yes, then please mark my post as a solution!
Thank you,
Vishesh Jain
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @MalcolmR,
You can use the BLANK() function in DAX along with the operator "==" which is strictly blank, which will ignore the 0s in your column and count the blanks.
You can use it in the another measure changing the condition in the filter argument of calculate.
Here is a link explaining the BLANK() function.
Hope this helps.
Thank you,
Vishesh Jain
If yes, then please mark my post as a solution!
Thank you,
Vishesh Jain
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-09-2024 03:26 AM | |||
02-07-2024 02:47 AM | |||
08-09-2024 03:31 AM | |||
08-29-2024 10:33 AM | |||
05-02-2024 03:11 PM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |