Help with dax code to filter results based on IF

[jmdesigns115]

Hello, I have two tables of data and i'm trying to pull them both into a single table and also filter the results based on IF.

Here is sample data and what i'm trying to accomplish.

I have a relationship between tbl1 and tbl2 on SKU. What i want to do is say IF(TBL1[skutype]=TEST-A, "Test-A", "test-B") what it's doing is duplicating the rows and showing me both TEST-A and TEST-B but i want it to only show me Test-A in the results. Basically if TEST-A and TEST-B both exist for SKU A to show Test-A only.

Input TBL1			Input TBL2
SKU	SKU TYPE		SKU	QTY	DATE
A	TEST-A		A	10	1/1/2020
A	TEST-A		A	10	1/1/2020
A	TEST-B		A	10	2/1/2020
B	TEST-A		B	10	1/4/2020
C	TEST-B		C	10	1/5/2020

	Desired output visual table	IF SKU IS SAME BUT TYPE IS DIFFERENT OVERRIDE AND SHOW TEST-A AND SUM QTY
SKU	QTY	Date	SKU TYPE
A	20	1/1/2020	TEST-A
A	10	2/1/2020	TEST-A
B	10	1/4/2020	TEST-A
C	10	1/5/2020	TEST-B

[andhiii079845]

Hi, 
to be honest i do not really understand your problem. You have a relationship betweeen both table with SKU. But it seems to be a m:n relationship. Because SKU "A" has "TEST-A" and "TEST-B", also duplicated values for SKU "A" and "Test-A" in table 1. Also your desired result is for my personal not clear. 

[tamerj1 · Accepted solution]

Hi @jmdesigns115 
Please refer to attached sample file with the solution

SKU TYPE = 
VAR CurrentSKUTypes = 
    CALCULATETABLE ( 
        VALUES ( TBL1[SKU TYPE] ), 
        REMOVEFILTERS ( ), 
        VALUES ( TBL1[SKU] ) 
    )
RETURN
    IF ( 
        NOT ISEMPTY ( TBL1 ) && HASONEVALUE ( TBL1[SKU] ),
        IF ( 
            "TEST-A" IN CurrentSKUTypes,
            "TEST-A",
            "TEST-B"
        )
    )

[andhiii079845]

One side questions: Can only superuser upload directly files in this forum? 

[tamerj1]

@andhiii079845 
Superusers, community support and perhaps Microsof employees

[jmdesigns115]

This feels like it's on the right track but my SKU Type comes up empty. Having troule figuring out why it's returning nothing.

[tamerj1]

@jmdesigns115 
Would you please update the same sample file with data that better simulates the actual case?

[jmdesigns115]

Thank you so much! Your solution worked. I accidentally chose new column instead of new measure when i used your solution. After making it a measure it worked.