Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DISTINCTCOUNT calculates wrong with filter

Guys! I'm having some difficulty in the filter context for the DISTINCTCOUNT expression. When I apply a filter to the measurements, it presents incorrect data, but when I use SUM or COUNT, the data ...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

    Thanks for the pbix.

    Can you explain a bit more about what we need to investigate? I see 2 rows of visuals.  Where is the error or wrong data displayed?

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

There are 2523 distinct values in the whole dataset for COD.  There is overlap of COD in the different Filter categories.

One example is for COD = 106.  There are rows for Filter = LT and rows for Filter = Na e LT.

So these values will be included in the distinctcount for [Total Count LT] and [Total Count NA e LT]

but they will only count as 1 in the [Total].

So the [Total] measure is accurate and the individual distinctcount measures are also accurate but the [Total] will be less

than adding up the individual measures.