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