distinctcount getting multiple hits

Question

Hello!&nbsp;I'm trying to get the distinct count function to determine the number of distinct batches we have made. I've used the following logic:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unique Batches = CALCULATE (
    DISTINCTCOUNT ('Production'[BatchNum]))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;And when I click in the sample data on each batch, I can see that in most cases, it's working.&nbsp; For example, B10059 has two batch numbers but is only counted as one, which is expected.&nbsp;&nbsp;However, there are a few where it's simply not working.&nbsp; Here, it's counted three times&nbsp;&nbsp;&nbsp;Querying the data, I don't see any issue with formatting. BatchNum is definitley the same and should only be counted once.&nbsp; There are three hits in the data set, but that shouldn't matter in this case if BatchNum has the same value.&nbsp;&nbsp;Any idea why I'm not always gettign a distinct count in Power BI? Many thanks in advance.&nbsp;&nbsp;&nbsp;

ba_pete · Accepted Answer

Hi&nbsp;formerlyknownas&nbsp;,
&nbsp;
Can you try using the following measure instead?
Unique Batches = DISTINCTCOUNT('Production'[BatchNum])
&nbsp;
There may be a context issue with the previous version.
&nbsp;
Pete&nbsp;

Forum Discussion

distinctcount getting multiple hits

2 Replies

Related content

DISTINCTCOUNT with filters

Problem using DISTINCTCOUNT with multiple filters

DistinctCount IF?

Getting distinct values for multiple columns

DISTINCTCOUNT with filters from multiple tables.