Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hello,
I am trying to work w/ VSTS as my Data Source and am running into an issue where a unique Work Item ID is being counted and/or displayed multiple times.
I have tried using the "Count (Distinct)" filter to remove duplicates, but it does not function as it has with other visualizations:
I'm still new with PowerBI and could really appreciate some guidance towards resolving this issue I'm having.
Not really enough information to go on, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Generally if you want to remove duplicates, create a new table with just those ID's and do a Remove Duplices in the Query Editor.
Not really sure what you are trying to do though. It looks like something is blowing out your table such that it isn't doing any kind of summarization of the values that you are showing.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!