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

    Maybe this makes more sense: the three distinct entries in "interest type" should all be their own individual tables in the model with Supplier ID as the PK

  • 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. 

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

    I have tried Calculatetable and group by. I really just want to create three new tables from the three unique data point in a single column, such that they have filter context.