Forum Discussion

Nyansapo's avatar
Nyansapo
Frequent Visitor
2 years ago
Solved

Auto-exist and duplicated measure problem when using two Dim tables in a visual

Dear PBI community,  I searched a lot about this issue on the forum and elsewhere, and I couldn't find the solution. Here is the situation.  Let's first present the data. I created a simple fake da...
Auto-exist
Duplicates
  • lbendlin's avatar
    lbendlin
    2 years ago
    But in reality, in my real data, I don't know the office to which an interviewer belong

    Then you cannot include both in the same visual.

lbendlin's avatar
lbendlin
Super User
2 years ago

The data model needs to follow the business scenario.  If your business scenario changes then you need to adjust your data model accordingly.

Nyansapo's avatar
Nyansapo
Frequent Visitor
2 years ago

Hi lbendlin , 
Thanks for your reply. Well, I made a mistake by adding the field Office ID to the Interviewer table. I did that only to show clearly that each Interviewer belong to an office. But in reality, in my real data, I don't know the office to which an interviewer belong, and I can only rely on the fact table. 

 

So in the specifc business scenario I'm refering to, what would you suggest? 

 

I'm sure there are a lot of scenario like this one, and I guess these is a relatively easy solution to fix this problem, but can't find it... 

 

Thank you very much, 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    But in reality, in my real data, I don't know the office to which an interviewer belong

    Then you cannot include both in the same visual.

    • Nyansapo's avatar
      Nyansapo
      Frequent Visitor
      2 years ago

      Hi lbendlin ,
      Thanks for the input, I really thought it was possible, I thought there would be a way to get this information from the fact table (without explicitly populating the dim table with it), but now that I think about that, your answer make sense. 

       

      Thanks a lot for your time and information, you got me out of my misunderstanding! Really appreciate! 🙂