Forum Discussion
Data Modeling for a concatenated column
I am working on a project in power bi when I making the data modeling, one of the columns has multiple values about country code, I want to separate them and then transform them into a dimension tabl...
NaveenGandhi
Memorable Member
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.