PowerBI Measure repeating rows

[sima_ue031]

Hi, I make a measure to show lost customer, for example : a customer without revenue in date range. 
But, for customers how dont have a revenue they make a duplicate rows. How to exclude this repeat?

My measure : 

Sales Last period2 =

Var DatumOd = cALCULATE(MIN(Datum[Datum]),ALLSELECTED(Datum))

Var DatumDO = CALCULATE(MAX(Datum[Datum]),ALLSELECTED(Datum))

VAR RazlikaUDanima = DATEDIFF(DatumDO,Datumod-1,DAY)

RETURN

CALCULATE(

IF(

ISBLANK(SUM(OTP[Iznos linije (LVT)])),0,SUM(OTP[Iznos linije (LVT)])),

DATESINPERIOD(Datum[Datum],DatumDO,RazlikaUDanima,day)

)

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[lbendlin]

What is your expected result based on the sample data you showed?

[sima_ue031]

You can see that my first comlumn and second repteat because my third colmn make this. I want to see only one row. 

[lbendlin]

Remove the trade column or use CONCATENATEX

[sima_ue031]

Hello, i would explain.
I made a mesure to show 0 when i dont have sales in date range.
And now, i have a model :Customer and Division. Each customerno have only one division, you can see on table abowe my table where i want to show 0 for sales .

And my customer no 00320 have a division AUTO. And i want to show only one row like this : 
CustomerNo    Division        Sales
00320               AUTO              0
I cant drop my column division because i need that. 

[lbendlin]

Power Query has no idea what division to pick in that scenario.  You need to provide the rules.  Would it always be AUTO? Would it be the first entry? Sorted by what?  Or would it be ok to pick a random value?

[sima_ue031]

No, i have a relationship to dimension table division and each customer only have one division.

[sima_ue031]

Hello, i need only one row here, second colmn this is all division in division table, but my customer have only one division for example AUTO.