Odd Filter Behavior

[kcantor]

I am attempting to work with Distinct Count on my items table. We currenlty have 152,000+ items listed and when I use the measure Number of Items=DISTINCTCOUNT('Item'[Code]) I get the correct number initially. My item table has no associated dates and is tied to my sales table using the code column. When I use the sales table to calculate qty sold, qty sold last year, and qty growth (sorting by category) it works beautifully. When I add a column showing the count of items we carry, the date filter seems to interfere with the item count. It goes from 152,000+ to 19,000.

Why is my date sorting messing with that measure? It works perfectly in PowerPivot.

[asocorro]

Is the relationship between the tables bi-directional?  This might be causing the reverse filtering.  Try to set it to one way.

[austinsense · Accepted solution]

You probably have a bi-directional relationship set up in Power BI.

[kcantor]

And that is why I stopped fighting it and asked here.  Something relatively simple was overlooked.

Thanks for the help. Both were solutions but could only mark one so I marked the top one.

@austinsense Don't tell Avi that I missed that one. He covered it in training.