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" )
    )
    )

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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" )
)
)