Forum Discussion

CTan42's avatar
CTan42
Helper II
9 years ago

Remove Duplicates?

Below are my power bi sample. I am asked to create a dashboard to present the stat of left orders. For examples, i do a calculation: orders= calculate(count(ID)). The result shows there are 5 orders....
Need Help
CTan42's avatar
CTan42
Helper II
9 years ago

TomMartens

thanks for your explanation. It's great that you mentioned the condition at the last. As my data have more than 1 row with exactly same date. Hence do you have any idea to do that? 

 

Regards,

Chung. 

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

I guess the row to use would be, the row with the MIN('table'[RemainingPayment].

 

So, without trying I would define a 2nd variable

minRemainingPayment = 
CALCULATE(
  MIN('table'[RemainingPayment])
)

and adjust the IF statement like so

IF('OrdersPayment'[Date] = latestOrderDate && 'OrdersPayment'[RemainingPayment] = minRemainigPayment

Hope this helps

 

Regards