Forum Discussion
Left outer join - matrix visual
Hello Power BI community, I'm struggling with a situation with the matrix visual. Please find below an image with the data model and some matrix situations to illustrate what I'm facing with and w...
Hello,
Unfortunately I'm not able to share the PBIX file.
Regarding your suggestion, I've got some questions. Let's say I create a new table (e.g. : DIM_ALL_LEVELS).
- Will the data model look like this?
- As I don't have a native hierarchy levels, I can't built it from DIM_LEVEL_1, DIM_LEVEL_2 and DIM_LEVEL_3. So it would mean I should built it from FACT_A which contains the 3 levels?
- Considering I could built this DIM_ALL_LEVELS table, don't you think I'm going to run into a many-to-many relationship problem?
Thanks.
Jinsoo
I think in order to truly understand what you are trying to do and why i really need an understanding of the business requirement here. what are level 1 - 3 based on? if you put them all into one table, why do you see there being a many to many relatioship issue? its hard to know without being able to see the data and undertstand what is the goal. Hope that makes sense. Also in order to group these levels together, one needs to understand the context of them