topic Re: Exclude values from an IF Statement if that value is found anywhere in another column in DAX Commands and Tips

Exclude values from an IF Statement if that value is found anywhere in another column

beanandrew18 — Mon, 20 May 2024 13:21:12 GMT

I have a table that has two different columns generating values based off of IF Statements. However, there is some overlap in the logic that causes values to populate in both columns. What I need is a DAX function that does not populate a value in column 2, if that same value is found in any row in column 1. If the value is not already somewhere in column 1, it can populate the value in column 2 See below.

The logic for column 1&2 is essentially:

IF(AND(Test 1 = x, Test 2 = y), Table['Part Number'], "")

Current Data:

Part Number	Column 1	Column 2
1510	1510	1510
1510	1510	1510
1510	1510	1510
1510		1510
1510		1510
1510
1700		1700
1700		1700

Needed Data:

Part Number	Column 1	Column 2
1510	1510
1510	1510
1510	1510
1510
1510
1510
1700		1700
1700		1700

Re: Exclude values from an IF Statement if that value is found anywhere in another column

Jihwan_Kim — Mon, 20 May 2024 14:06:21 GMT

Hi,

I am not sure if I understood your logic correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

It is for creating a new table.

expected result table = VAR _list = VALUES(Data[Column 1]) VAR _t = SELECTCOLUMNS( Data, "@part_number", Data[Part Number], "@column01", Data[Column 1], "@column02", IF( NOT (Data[Column 2] IN _list), Data[Column 2] ) ) RETURN _t

Re: Exclude values from an IF Statement if that value is found anywhere in another column

chaoat — Wed, 22 May 2024 05:46:37 GMT

非常棒，你帮助了我。
并为我提供了新思路！