Forum Discussion
Dupplicate Rows, relationship issues
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
3 Replies
Change the bidirectional link to single, merge the Keys and Targets tables.
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-Forum/ba-p/963216
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/1447523
