Forum Discussion
Odd Filter Behavior
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.
You probably have a bi-directional relationship set up in Power BI.
3 Replies
You probably have a bi-directional relationship set up in Power BI.
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.
Is the relationship between the tables bi-directional? This might be causing the reverse filtering. Try to set it to one way.
