I am a new user to both the Enterprise DNA site and a newbie when it comes to PowerBI and DAX!
I have been tasked to create a report that shows the sum of each of our products revenue/ship amount by fiscal year, month etc. We are an HVAC company and have several air conditioning products that all have different nomenclature for the product code string (usually 17-20 characters long)
I would like to create a measure that sums up our revenue for each of these products. The issue is that while we have one large database, it lumps all of the products, accessories, and parts together. So far I have created a page in Power Bi for each of our products and used the page level filter function to show the relevant data for that specific product only.
This table is what I have created so far (with the specific customer and product info blurred out).
As you can see, this works okay to create a table for a specific product, but when I need to use any measures or drill down into the data more , I need a more comprehensive solution.
How can I create a DAX measure that takes into account multiple criteria like (“starts with XXX”, “does not contain XXX”, but only by using DAX to sum the correct ship amount ( for each product, without having other products contaminate that number?