Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I have two tables with contacts from two different sources and I created a third table so I could merge the contacts based on their URL since the url for each contact is the same for both sources, this way I can see what contacts from the second source are the same as the ones in the first source.
Connections
This is the model view of my data where K2 Data is the first source and Connected_data is the second source and these are merged in Connected_data.
For my bar chart I created the measure:
@al0981 - if Connected data is the table that has the contacts from both sources you will need to use this for the slicer.
You will also need to make sure you use a column that is populated with data that comes from both tables in the slicer. My suspicion is that the column that you have used from Connected_data only has data from this table, and the rows for K2 are blank, hence why your filter is only applied to half the visual.
If that's not the case, it's going to be your relationships, and specifically it will be the fact that the relationship from CRM Data to Stage only works in one direction. You can try editing your measure to something like the below:
Total Data of Phases =
CALCULATE(
COUNTROWS(Distinct(Union(
VALUES('K2 Data'[id]),
VALUES(Connected_data[id])
))), CROSSFILTER( CRM_data[relationship column], Stage[relationship column], BOTH)
If this works for you, please accept it as the solution.
Hi Mark,
The Connected_data table is the merge of the other 2 tables based on the URL of the contats, so this one will have 10 contacts that are coincident to the two tables while the other tables have hundreds of contacts.
I tried changing the relationships from connected_data - CRM_data to Connected_data - K2 Data and trying that measure but I just get the contacts from K2 data and the contacts from the other table don't show up at all.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
17 | |
14 | |
10 | |
9 | |
6 |