Forum Discussion
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...
you don't really need DAX for that. But a small change to the data model is required.
But in reality, in my real data, I don't know the office to which an interviewer belongThen you cannot include both in the same visual.
But in reality, in my real data, I don't know the office to which an interviewer belongThen you cannot include both in the same visual.
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! 🙂