Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |