Forum Discussion
Validate bridge table
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
It might be better to do that via the common fact table.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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
Your projects table is not a proper dimension table. Try to normalize it.