Forum Discussion

Regular Visitor

3 years ago

Identify shops with an inventory overlap

Dear Power BI community, I am facing an issue where I need to compare which shops have released a specific product and compare which stores have an overlap with other products. I would like to s...

Icon for Super User rank

Super User

3 years ago

Sounds like you're on the right track. What do you need help with?

MrHecht
Regular Visitor
3 years ago
Hello Ibendlin,

Thanks for answer!

I am having difficulty finding the DAX code that creates a selected product shop overview and allows me to see the overlap. I am currently stuck because my current matrix compares all products against each other, and I am unsure how to select a specific product.

It should be a dynamic function since I would like to change the selection of produts while using the report.
- lbendlin
  Super User
  3 years ago
  Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
  If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
  Please show the expected outcome based on the sample data you provided.
  
  If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Related content