Dax Logic

[lherbert501]

Hi,

Could somebody please help me with some Dax?

Location 1 and Location 2 are theorietically the same thing but are in my system twice and I need to say, if the qty column is greater than 0 and it matches on the item,loaddate and country, then the location 1 has to take priority and to ignore the item on location 2 but specifically only if it it a match and exists on location 1. There can be occasions where location 2 will have a qty and location 1 wont, but location 1 always has priority.

[Ahmedx]

look carefully, this is what you are looking for

[lherbert501]

@Ahmedx  Thanks for your reply.

Could you please explain a bit more?

Thanks

[Ahmedx]

should I explain it or should you
I just wanted to reproduce your logic if I understood correctly
added a new column and there should be the word priority

[lherbert501]

I need something like 

If Location =' Location 1' and item,date and country match to location 2's  (so it already exists for the other location) then take quantity from location 1, else location 2. 

[v-xinruzhu-msft · Accepted solution]

Hi @lherbert501 

You can refer to the following solution.

The sample data is the same as yours

1.Create a rank column

Rank =
RANKX (
    FILTER (
        'Table',
        [Item] = EARLIER ( 'Table'[Item] )
            && [Date] = EARLIER ( 'Table'[Date] )
            && [Country] = EARLIER ( 'Table'[Country] )
    ),
    [Location],
    ,
    ASC
)

2.Create a result column

Result = IF([Rank]=1,[Qty]) 

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lherbert501]

Thankyou @v-xinruzhu-msft