Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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 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.
I must have double uploaded the data in my bulk upload.
Thank you!
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |