Forum Discussion

tkrupka's avatar
tkrupka
Resolver II
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
tkrupka
Resolver II
6 years ago

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

 

Thank you!