Relationships in Power BI

[Analitika]

Hello,

I would like to ask how to fix not showing duplicates in Power BI visual? I made relationship but still see duplicates in visual.

Relationship wasa many-to one.

Visual having duplicates, last column.

Here is a relationship: 

[AncaZ]

Hi @Analitika ,

In your image, I see that the third column contains different data for each row. So the row is not technically duplicated. Did you try taking the third column out? Is the data still duplicated?

[Greg_Deckler]

@Analitika Is the last column a calculation or ?

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Analitika]

I can't publish .pbix because it is a sensitive data. 

It sums all amount instead showing each client sum value. Instead of 620 it sums 620+620+620 as per one client. That is not correct

I am using column from skolup table.

Here is the relationship between tables. 

[v-yiruan-msft]

Hi  @Analitika ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[v-yiruan-msft]

Hi @Analitika ,

You can refer the following links to get it.

Sum distinct values for first occurance in Power BI

Power BI DAX Function To Find Unique or Duplicate Values in Power BI

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards