Forum Discussion

kcantor's avatar
kcantor
Community 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.

austinsense's avatar
austinsense
Impactful Individual
10 years ago

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

kcantor's avatar
kcantor
Community Champion
10 years ago

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.