How to check if value is in another table with additional condition and print 0 or 1

Anonymous — Sun, 12 Nov 2023 12:17:29 GMT

Hi,

I'm trying to build a command to first check if a value is in one of two tables while fulfilling a condition, and then print either 0 or 1 to a column. I'm having trouble combining these all to one command.

So, first I want to check if a value on table1 is on table2 or table3 AND marked on the same row as type a. If the value is found on either of the tables as type a, then command should return 1 to the column on table 1. Otherwise, if the value is not found or is not marked type a, it should return 0 to the column.

I'm basically wanting to combine an IF ELSE structure with an additional condition. How could this be done efficiently?

Re: How to check if value is in another table with additional condition and print 0 or 1

ValtteriN — Sun, 12 Nov 2023 13:40:35 GMT

Hi,

I am not sure if I understood, but here is an attempt:

Table1:

Table2

Table3:

Here in table1 we have Type A Dimension AA and Type B dimension AA which are found in table 2 or 3 with matching values. These rows should get a value 1 in our dax.

Dax:

Test for match in tables with matching values in filter context =

var _type = MAX('Table (16)'[Type])

var _dimension = MAX('Table (16)'[Dimension])

var _testTable2 = COUNTROWS(FILTER('Table (17)','Table (17)'[Type]=_type && 'Table (17)'[Dimension] = _dimension))

var _testTable3 = COUNTROWS(FILTER('Table (18)','Table (18)'[Type]=_type && 'Table (18)'[Column1] = _dimension)) //filter the test tables with the current context values

return

IF(OR(_testTable2>0,_testTable3>0),1,0)

End Result:

The result seems to match the expectation.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

topic How to check if value is in another table with additional condition and print 0 or 1 in DAX Commands and Tips

How to check if value is in another table with additional condition and print 0 or 1

Re: How to check if value is in another table with additional condition and print 0 or 1