- 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

Problem with Measure using COUNT or DISTINCTCOUNT (values not being counted)
Hello,
I am trying to use a measure that uses DISTINCTCOUNT and several of my items are not being counted.
I have simplified my measure to the minimum (eliminated all filters and conditions) to troubleshoot and even just a basic COUNT is not working as expected. I am down to a table with 2 items in it, I am trying to count the number of items based the field named PR ID.
When I add the field to a table (or a bar chart) and use Count or Count (Distinct), I get the expected count of 2.
When I use a Measure with COUNT or DISTINCTCOUNT from that same field, only one of the 2 items is being counted and I get a result of 1 (instead of 2).
Any help with what might be going on would be greatly appreciated as I cannot figure out what might be going on here.
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you @Bmejia, the table that the measure was in had a filter that carried over from my copy/paste and I did not realize it (and feel pretty bad for not seeing that!) . All good now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I would double check you don't have anything filtering the measures. I recreated the same measure with just the two PR ID and I am getting 2 not 1. )-:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you @Bmejia, the table that the measure was in had a filter that carried over from my copy/paste and I did not realize it (and feel pretty bad for not seeing that!) . All good now.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-02-2023 03:23 PM | |||
08-22-2024 11:56 PM | |||
Anonymous
| 03-10-2023 08:20 AM | ||
11-25-2020 03:59 AM | |||
Anonymous
| 02-10-2024 05:07 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |