Forum Discussion
why the count is not right
Anonymous, 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 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.
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.
Super UserAnonymous, 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.
- amitchandak
Anonymous 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.
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
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.
Anonymous Thank you SO much! You are right. When I updated the Power BI version and reselected the filter of year, it works.