why the count is not right

[laurelning]

Hello everyone,

          I am new to Power Bi and this is a very simple question. While creating a table of counts for each category ( in text) under a column, I don't know why the number of counts is not right based on data. I checked the data table imported to Power BI from excel and it is all correct. But the number of counts is not right. Does anyone know what's going on? 

Thanks.

[amitchandak · Accepted solution]

@laurelning, It is difficult to get the reason from the info.  Try following

1. Remove all filters and check for Count As KPI and in the table of data you created is matching or not. Basically only from one table. If this one matches then

2. The add filter and check which filter is causing that

3. If step one is giving the wrong count, then try import this file(table) into a new file and try to check for the count.

[Anonymous]

Dear laurelning,

Could you provide more information or screenshoot please ?

So i can help u for your case

Regards,

Chrisyan

[laurelning]

@Anonymous  Please see below the screenshot of the two tables generated respectively from Excel and Power BI. Thanks.

[Greg_Deckler]

Going to need source data to figure out what is going on here, can you replicate the issue with sample data or can you share the source data? Are there multiple source tables involved or just one?

[laurelning]

@Greg_Deckler just one source data. The excel table was generated based on the source data. 

[Greg_Deckler]

OK, so your data is a single table like the following?

Contact,Client Role

Greg,Affiliated Contact

George,Campus Sponsor Contact

Jill,Affiliated Contact

And out of that data, you would expect to see "Affiliated Contact" at 66.67% and "Campus Sponsor Contact" at 33.33%?

[laurelning]

Here is another screenshoot of the matrix visual in Power BI. Did I set it up wrong? Don't know what is going on? Help or any thoughts is appreciated!

[amitchandak]

Just check the overall count of rows. Put a KPI here and do a count of rows in excel. Are they coming the same?

Second Check if it count distinct in Excel.

[laurelning]

@amitchandak 

The count of total rows of the data model in Power BI is exactly the same as that in the source data in excel. The filtered row for each category in Power BI is also the same as the excel ( see the screenshoot). But somehow the counts of each category in matrix and pi chart visuals are not right. 

[amitchandak · Accepted solution]

@laurelning, It is difficult to get the reason from the info.  Try following

1. Remove all filters and check for Count As KPI and in the table of data you created is matching or not. Basically only from one table. If this one matches then

2. The add filter and check which filter is causing that

3. If step one is giving the wrong count, then try import this file(table) into a new file and try to check for the count.

[laurelning]

@amitchandak  Sorry if this is too simple, could you give me a clue of how to use KPI for count. I am new to Power BI, afraid that I would do it wrong. Thanks.

[amitchandak]

[laurelning]

@amitchandak  Thank you so much. Following your step gives me the right count. But why the filter of year doesn't work?  The report will be used by someone who has very minimum knowledge of Power BI for group retreat. The filter of Year up in the corner for them to (un)check is the best option. I am just wondering how this KPI can be used for easy (un)check. Thanks again. 

[amitchandak · Accepted solution]

@laurelning is the filter you have taken in filter pane and one on slicer is from the same column and same table. 

If they are not the same that will open up the option to debug further. 

Not sure if you are using latest version of powerBI, Filter pane is much better in latest version.

[laurelning]

@Anonymous  Thank you SO much! You are right. When I updated the Power BI version and reselected the filter of year, it works. 

[laurelning]

@Greg_Deckler Yes. You are right.

[Anonymous]

@laurelning 

We need the raw data in order to troubleshoot your issue.

Please provide the original data source.

Cheers!
A

[Greg_Deckler]

Nope, no idea based on what you have provided. Could be an issue with casing in a text column and what is considered unique. Could be a bunch of things but it all depends on your data, relationships, etc. 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