topic Column Comparison - Vlookup in DAX Commands and Tips

Column Comparison - Vlookup

TylerVono — Sat, 08 Apr 2023 02:50:52 GMT

I have two columns I need to compare, one column: 'MOM Stocking Report': Shows all stocked items & 'Demand Seg': Shows the complete list of purchased items.

I need to compare them against one another to know which ones are stocked and which are not.

As you can see the equation below, it appears to get me halfway there as the pie chart does capture the data, however I am not certain this is correct, Also when I click on the 'YES' stocked pie chart, the table shows nothing. Also, technically the 'Agreement Level' should be a 0 if 'Not Stocked' or come back with null.

My relationship cardinality is at Many to Many , it wont let me change- I have removed all duplicates from Power Query. So I am basically out of ideas:

My Stock or Not Equation:

Stocking Agreement? = if(isblank(countx(filter('MOM Stocking Report','MOM Stocking Report'[Item Number]='Demand Seg'[ITEM NUMBER]),'MOM Stocking Report'[Item Number])),"YES","NO")

Re: Column Comparison - Vlookup

tamerj1 — Sat, 08 Apr 2023 09:06:15 GMT

Hi TylerVono
Please try

Stocking Agreement? = IF ( ISEMPTY ( FILTER ( RELATEDTABLE ( 'MOM Stocking Report' ), 'MOM Stocking Report'[Item Number] = 'Demand Seg'[ITEM NUMBER] ) ), "YES", "NO" )

Re: Column Comparison - Vlookup

TylerVono — Sat, 08 Apr 2023 14:21:17 GMT

Hi There Tamerj1, I tried the equation and the same thing happens, the 'YES' result will not show up on the table, I dont think they're comparing against one another. See below, do you have any other ideas? I have a Many to Many cardinality for 'Item Number', it says there are duplicates but as you can see I removed them: