Setup data model between multiple dimension table

Power BI Data Model
1

Hi all,

I have 1 fact table with data about the goal for several metrics. My company has Project A and Project B, and there will be metrics corresponding to each project (Some metrics can be in both projects). I also have a Team table which includes Division of these teams. Project A includes Division 1 to Division 5, Project B includes Division X.

I want to filter goals by Division through metric. Ex, When I filter any division from 1 to 5, it shows the goal of the metric which is in Project A and Project A+B. When I filter division X, it shows goals in Project B and Project A+B, and if I select all, it returns all metrics. How can I set this model up to achieve this result?

This is an example of data in Power BI.
Question_about_DataModelling.pbix (35.0 KB)

2

Hi @collier.brittany

Due to inactivity, we’d like to conclude that your inquiry was out of the experts’ and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!