Forum Discussion
Data modelling
Hi KNP ,
Since Analyst26 mentioned he unable to share sample data due to confidentiality. I shared an approach based on common best practices that have worked well in similar scenarios. Additionally I refer the sources that are helpful for data modeling and I studied from it to provide a solution.
When dealing with multiple data tables that share common fields like Product, Department, and Company, it is often more effective to avoid many-to-many relationships. Instead, building separate dimension tables for each of these fields and connecting them through one-to-many relationships usually provides more consistent and reliable filtering in visuals like matrices.
Also, creating DAX measures instead of using raw columns directly helps avoid issues with blanks values.
Best Regards,
Nasif Azam
Hi Nasif_Azam,
It's not the content of the answer I have a problem with. It's the fact that it is clearly copy/pasted directly from ChatGPT and there isn't enough information to come to those conclusions. This is why I asked Analyst26 to mask any sensitive information prior to sharing his datasets. We simple don't have enough information to provide a good answer.
I respect that you're taking the time to try and help people Nasif_Azam, I think you could do better than pasting from a system that often gets things wrong and you've clearly not been able to validate your answer with the information available.