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.

Nyansapo's avatar
Nyansapo
Frequent Visitor
2 years ago

Hi lbendlin ,

Thanks a lot for your quick reply! Your solution definitly works in this context, but here is my question : How if I would not have had Office ID in my Interviewer dim table? Let say we wouldn't know who is working where, but would only have the actual transactions in the fact table. I would like to be able to set my measure or my visual so that Power BI do not create row conbinations of Interviewers and Offices that do not exist in the fact table. This is a situation I often encounter. Is there any ways to do that?

I can of course extract the data from the fact table and feed it into my dim table, but would really like to avoid this kind of manipulation.

 

Thank you very much! 🙂

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! 🙂