I previously added a Count(Terms) as a measure to my pivot table but the issue is that each ID has lots of terms and that is acceptable. The issue arises when a single location has lots of terms. I have an ID with 25 terms but when I expand on location, each location only has one term associated with it (which is correct). If it has more than 1, it's wrong but I definitely don't want to have to drill down into each of the 60K IDs.
I don't believe I can do count location either because each ID will have lots of locations.
I guess I could do a Count(Location) and a Count(terms) and if the 2 counts don't match there is an issue. Is there a way to limit to only those? Or highlight those IDs?
Coming across an interesting issue. Some of the data points have duplicate Location but the terms are the same. Is there a way to differentiate this?
ID Location Term
3 B Net0
3 B Net 0
3 B Net 0
4 G Net 30
4 G Net 60
4 G Net 1
In the above example ID 4 is more important because of the conflicting information but I'd like to know that there is duplicate information on ID 3.
Thanks in advance!