Forum Discussion
Count is doubled
I hadn't seen this issue in other attempts, but I am at a loss.
I have a list of tanks that has been sliced by the location field.
In this case there are 3 lines with DAY_Tank as FALSE and 10 lines of TRUE.
But if you look in the filter column it lists 6 and 20 which makes absolutely no sense.
I've looked at my data tables and see nothing more than the line items you see above.
If I do a SUM of the capacity it gives me exactly double of what it should be.
What am I missing?
tkrupka I checked the data for Boston. You are seeing the double count because for each Tank_Name, there are two Tank_IDs. e.g. for Tank Name BO2-Fuel System B, the Tank IDs are 462 and 75. Hence, although Power BI is not showing these 2 records in the visual, underneath it is showing the filter count for the actual no. of rows. It is the same reason why your SUM is also double along with True/False count for Tanks[Day_Tank]. Please see attached screenshot.
4 Replies
Would you be able to share your .pbix file?
tkrupka I checked the data for Boston. You are seeing the double count because for each Tank_Name, there are two Tank_IDs. e.g. for Tank Name BO2-Fuel System B, the Tank IDs are 462 and 75. Hence, although Power BI is not showing these 2 records in the visual, underneath it is showing the filter count for the actual no. of rows. It is the same reason why your SUM is also double along with True/False count for Tanks[Day_Tank]. Please see attached screenshot.
