Forum Discussion
Advocate IStumped: return all within a category
OK, the solution to this would take a bit to explain so just attaching the file. Most important point, separate, unrelated UPC table.
Community ChampionNo worries, that's why I created that post!
I believe in your case in playing with your data is that in your table visualization you need to click the little drop down arrow next to your columns in your Values area and set "Don't summarize". Let me know if that works.
Advocate IHi Greg, that's good to know for other projects, but still limits me to only the UPC selected.
I'm kind of trying to go backwards. If I could make it say something, it would say...Find the article of the selected UPC, then filter the visual to show all UPC's that live within that article, not only the one selected.
It's counterintuitive to everything I know about filters, but DAX has opened a whole new world of what's possible.
Thank you for your reply.
- Greg_Deckler
Oh, I think I get what you are trying to do. So, let me state this back to you to make sure I understand. You want to pick a UPC. That UPC is tied to a an article. You want to return all other rows that have that same Article ID, correct?
- RyanAck
Yes exactly! Thanks for saying that so much more poetically than my attempt.
- Greg_Deckler
OK, the solution to this would take a bit to explain so just attaching the file. Most important point, separate, unrelated UPC table.