Forum Discussion

PhilSmith's avatar
PhilSmith
Icon for Helper III rankHelper III
4 years ago
Solved

Many to Many my only option with one table created by Distinct

I have a sales table, (many duplicates,) and I am trying to create a One to Many relationship with CustomerBrandCatActive.  This table will ultimately be a bridge.  There are no other relationships c...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure how your CustomerBrandCat table looks like, but please try the below.

    Or, please share your sample pbix file.

     

     

    CustomerBrandCatActive =
    DISTINCT (
    CALCULATETABLE (
    SUMMARIZE ( CustomerBrandCat, CustomerBrandCat[Active] ),
    FILTER ( CustomerBrandCat, CustomerBrandCat[Active] <> "N" )
    )
    )

PhilSmith's avatar
PhilSmith
Icon for Helper III rankHelper III
4 years ago

Thank you.   This works.  I would love to know why it works though.  The results in the table are are different, by about 40 records.  The results are too big to export, so I can't just compare what is being returned by each option.