Count is doubled

[tkrupka]

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?

[jdbuchanan71]

@tkrupka 

Would you be able to share your .pbix file?

[tkrupka]

@jdbuchanan71 

Let's try this.

[Anonymous · Accepted solution]

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

[tkrupka]

I must have double uploaded the data in my bulk upload.

Thank you!