PowerBI Measure repeating rows

Question

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 · Answer

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

anonymous · Answer

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

lbendlin · Answer

Remove the trade column or use CONCATENATEX

anonymous · Answer

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.&nbsp;&nbsp;

anonymous · Answer

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 .&nbsp;And my customer no 00320 have a division AUTO. And i want to show only one row like this :&nbsp;CustomerNo&nbsp; &nbsp; Division&nbsp; &nbsp; &nbsp; &nbsp; Sales00320&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AUTO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0I cant drop my column division because i need that.&nbsp;

Forum Discussion

PowerBI Measure repeating rows

8 Replies

Related content

Paginated Report headers not repeating

Measure Calculates Correctly but Repeats Across Every Single TransactionID

PowerBI measure IF statement

Measure to count repeats

Measures PowerBI