Forum Discussion
Data Modeling for a concatenated column
Hello NaveenGandhi
Thanks for your help.
In fact, I am training on a dataset from the net, I took it from this site
Products Catalog - from E-commerce Retail site NewChic.com - dataset by jfreex | data.world
I want to learn the optimized way to modeling the data.
Memorable MemberMays-Alreem
Check the attached PBIX. Basically this will allow you to use unique CodCountry to be used in a slicer and filter the accessories table data accordingly. I have created a measure "Filter_" and used in the tables visual level fitler.
Since the CodCountry is just a representation of cod available for countries, there is no much use in trying to make it as a dim table anyways.
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
- Thanks alot for your efforts but this way will remove alot of records, I solved it with many to many relationship as in the pictures I put above, the problem was the direction of the cardinality it was one at the side of the fact table but it's worked good then used the crossfilter function in DAX in some visuals... Thanks again for your help.