How to rank sales on one line

[SomeDataDude]

Hello,

I need help formulating dax measure. The image below shows that for OrderID 1717694 the amount is 696.67. This is now shown on all 5 lines. However, I only want to see this on 1 line.

This is the output I am looking for:

In SQL I use the following code to organize this:

iif(
     RANK () 
      OVER (  
       PARTITION BY Table1.invkey 
        ORDER BY Table1.OrderID, Table2.ordsubtaskno, Table3.goodid DESC ) =1, 
          Table4.Amounttwv,0) 'TotalAmount',

How do i do this with dax. Or is this not possible?

I've already tried it with RankX and Rank.EQ. But probably I'm not applying it right.

[onurbmiguel_]

Hi SomeDataDude

Can you share some sample of your data, to understand how you have structure the information.

BR 

Bruno 

[SomeDataDude]

Hi @onurbmiguel_ 

Thanks for replying. 

I have prepared an example file. In this example, I have merged multiple tables in Query1. The amount is taken from table Query2.

If you have any questions, let me know.

You can download the pbix file via the following link: https://we.tl/t-gDSbxD7qs5 

[onurbmiguel_ · Accepted solution]

Hi again, 

It will be something like this? 

the DAX for the new measure: 

TotaalAmount 2 = 
var _id = SELECTEDVALUE(Query1[OrderId])
var _control = 
    CALCULATE(
        min(Query1[DeliveryRealTime]),
        FILTER(ALL(Query1),Query1[OrderId]= _id))
return 
if(min(Query1[DeliveryRealTime]) = _control, [TotaalAmount], BLANK())

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

[SomeDataDude]

Hi, 

Yes, this works!

Thank you very much!