PowerBI returns values obviously wrong

PaulDBrown Greg_Deckler 

Like said, I can't.

Of course I can post a table with 20 rows and tell what I except the outcome to be- and it will be the outcome. It works in all of my data dummysets with <100 rows.

But when I apply it onto real world data, those kind of mistakes happen; somewhere in between the thousands of rows I got. And I can't share the file with you as I can't attach it; also its business data my employer would not be happy to see publibly disclosed. That's why numeric examples don't make sense here.

I also don't expect tailorfit solutions but maybe advice from people who managed to solve a somewhat similiar issue or tips how to fix such issues in general... I Can't just share the data with you.

Like said, my problem is that PowerBI, for example, counts 190k values when I look onto the table,

but when I count the Sales Docs. in a visual, its only 30k

No filters applied, no distinct count, nothing.

And I don't know why. And I don't know how to overcome that issue. But I most overcome it; report quality is crucial for my boss. 

And I think when I fix this, hopefully, a number of wicked numbers that are definitely wrong (I calculated the outcome manually to be sure) could be fixed alongside.