Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
huguestremblay
Helper II
Helper II

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).

 

huguestremblay_0-1680723409422.png

Any help with what might be going on would be greatly appreciated as I cannot figure out what might be going on here.

Thanks!

1 ACCEPTED SOLUTION

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.  

View solution in original post

2 REPLIES 2
Bmejia
Solution Supplier
Solution Supplier

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. )-:

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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.