Forum Discussion
Dax Logic
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.
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.
6 Replies
look carefully, this is what you are looking for
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
