Forum Discussion

chonchar's avatar
chonchar
Icon for Helper V rankHelper V
3 years ago

Extract/Create New Table

Morning, All,   I have a sinlge table in my model called "Supplier Interests." One of the column names is "Interest Type." In this intrest type column, there are about 60 different values. Some are...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Is there a distinction between Region and Line of Business?

chonchar's avatar
chonchar
Icon for Helper V rankHelper V
3 years ago

In the Interest Type Column there are 3 distinct data points. Indusrty, Project, and Region. I want to separate all 3 of those into their own tables with Supplier ID being the Primary Key. Then add all three of those tables, filter context created, so be able to visualize: Supplier ID->Region-> and then the line of business as the final part. 

 

I have tried creating a hierarchy, adding new tables, (may have the wrong DAX), and other filter context creating DAX.