Forum Discussion
Solved
Filter without losing data across other columns
Hi, Newer PBI user here. I am trying to filter a table by quantity sold of Product A, while not losing the quantity sold of Product B. The source table contains one product per order per line along ...
I ended up discovering the SUMMARIZE function and consolidating the table down to one line per salesperson. That was easier to work with than the multiple rows.
Ashish_Mathur
Super User
Super UserHi,
Your first question should get answered by my solution in the attached file.
Hope this helps.
Thank you! I ended up consolidating the table (which I wasn't originally planning to do and didn't ask about) because that was easier to work with. I still appreciate your response because I learned about a couple new functions I didn't know about (ex. REMOVEFILTERS).