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

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    If I add the distinct counts, I don't get the total of 2,523 but rather 2,582. This difference only happens when I use the DISTINCTCOUNT expression. If you look at the second line of data, the sum is correct at 8,070, which I used COUNT.