Forum Discussion

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago
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 ...
Need Help
  • austinsense's avatar
    austinsense
    10 years ago

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

asocorro's avatar
asocorro
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

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