Forum Discussion

kasife's avatar
kasife
Helper V
2 years ago
Solved

Validate bridge table

Hi Guys, I created a guide to create a bridge table, but I'm not sure if it's correct. Because this measure ends up giving me all the possibilities between the two dimension tables. What would be ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

     

    Total brokers = COUNTROWS(DISTINCT(UNION(
    SELECTCOLUMNS(Leads,"Broker",[idcorretor]),
    SELECTCOLUMNS(pastas,"B",[idcorretor]),
    SELECTCOLUMNS(ccvs,"B",[idcorretor]),
    SELECTCOLUMNS(Repasses,"B",[idcorretor]))))

// distinct count of brokers that are in the tables: Leads, pastas, ccvs and repasses
// The tables are related by ID, but the broker count must be by name

     

kasife's avatar
kasife
Helper V
2 years ago

lbendlinI created a model to try and better show what I would like to achieve. But I have two dimension tables and I need to use both to make some measurements. For example: the sale of each broker per project, the Total of brokers per project. etc...Follow the link below with the file
https://ufile.io/liju6ybx

lbendlin's avatar
lbendlin
Super User
2 years ago

Your projects table is not a proper dimension table.  Try to normalize it.

 

 

  • kasife's avatar
    kasife
    Helper V
    2 years ago

    lbendlin Okay, I'll do that, but Assuming it was normalized, how would I get the result?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Please provide sample data that fully covers your issue.
      Please show the expected outcome based on the sample data you provided.