Forum Discussion
Create Virtual Flag in Data with DAX Measure
Hi TexasStone if it is possible in your "upstream" before Power BI, filter out data already like Product[Product Name] = "ABC", this way will make your life easier?
When you use part REMOVEFILTERS, it literally remove filters and show totals (in this case for ABS product).
Another option in your case could be using CALCULATETABLE after you "import" data into Power BI using simple filter link on link with example
I don't think so. I think it's super easy for me to just return the Revenue associated only with Product ABC either by filtering the visual or creating the measure.
What I don't understand however is to see all of the product details of any order that contains ABC. It seems like I need to be able to filter to a list of order numbers that contain ABC and then pass that list of order numbers to another measure to return all of the results.
Looking at the example you sent it seems like if I simply did calculatetable and filtered to product = ABC then I'd only be seeing those ABC product rows. I need to see all of the rows in the table for any order number containing ABC. So somehow I need to set a filter for ABC, but then also see products DEF, GHI in the results. Hopefully that makes sense.