Forum Discussion

Dimis_e's avatar
Dimis_e
Regular Visitor
7 years ago
Solved

Multiple Relationships Between Tables

Hello,   I am pretty new in power bi with some knowledge from here and there and a lot of google search... My issue is this:   I have two tables (one with actuals and one with targets) both with ...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hi Dimis_e

     

    you need to create a model like the below. The top dimension table will filter both sales and actuals

     

     

     

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Dimis_e

 

is it possible to post a sample data?

Dimis_e's avatar
Dimis_e
Regular Visitor
7 years ago

Here is an example

 

 

 

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Dimis_e

     

    I would create separate dimension for Asset, People, Technology, Process 

     

     

    • Dimis_e's avatar
      Dimis_e
      Regular Visitor
      7 years ago

      You mean seperate RegionCountry tables by each one of the 4 parameters?

      • LivioLanzo's avatar
        LivioLanzo
        Icon for Solution Sage rankSolution Sage
        7 years ago

        Hi Dimis_e,

         

        is the table you've shown a dimension or a fact table. Could you show both the dimension and fact?