Forum Discussion
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 ...
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
lbendlin I tried to do it in a way that can convey what I need. I also tried to adjust the modeling.
https://ufile.io/plitf8og
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