Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Currently I have this 4 tables I have a dilema.
"00 Campaign Performance"
"00 Key Master Data"
"00 Targets"
"00 Google ads"
the relationships I have between this situation
creates me different values for FCT when it should be constants
and this following table (which it should be like this)
and when I change the relationship of "00 Campaign perf" to a single direction, the graph I want works and shows how it suppose to be however the table brings me duplicates with the Currency
Wher enow the graph works
But now the table shows like this
Do you know why is the issue, how could I fix this
I did what u mentioned but still I get this
and
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Change the bidirectional link to single, merge the Keys and Targets tables.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 27 | |
| 24 | |
| 24 | |
| 18 |
| User | Count |
|---|---|
| 54 | |
| 50 | |
| 41 | |
| 33 | |
| 29 |