PowerBI returns values obviously wrong

[Anonymous]

Hi all,

I have to create a report and to ensure the quality I regularly calculate certain values by hand (or better: by Excel) to make sure PowerBI doesn't deliver false results.

What it does. My report consists of a quite a few calculated columns, tables etc., but it should all work just fine as it did with the dammy dataset I tried it on.

One step further, the errors are actually quite abvious. For example a Column "Sales Documents".

If I look in the Column, PowerBi tells me that the Column "Sales Docs" consists of 190.000 values.

However, wenn I use the card visual and make it display the count of Sales Docs, it tells me that the Column only consists of 30.000 values.

No filters applied, no slicers activated, no edgy relationships established, nothing. 

I believe this could be the reason for all of my problems and would appreciate if any of you could help me out with the issue... Cause I have absolutely no clue....

[v-yangliu-msft]

Hi  @Anonymous ,

Can you publish the measure formula so that you can better see the problem:

You can try to calculate the number of rows by changing the measurement to this:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

@Anonymous 

We will be happy to help, but need specific information. Please read this explanatory thread:

How to get your question answered quickly 

[Anonymous]

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

[PaulDBrown]

@Anonymous 

So what measures are you using? COUNTROWS? COUNT?...

If you use a measure like COUNTROWS('Table') you will get the number of rows in the table (in the filter context) if that is what you need.

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Sharing your PBIX may be the only way to get to the bottom of it.