Forum Discussion
VSTS Duplicate Work Item IDs
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.
1 Reply
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.
