topic Re: DAX IF OR formula to filter NOT BLANK VALUES from Related tables in DAX Commands and Tips

DAX IF OR formula to filter NOT BLANK VALUES from Related tables

Anonymous — Mon, 27 Apr 2020 10:07:43 GMT

Hello,

I have two tables that have 1-1 relationship (via ID field) I would like to display values from both tables in one table( visual) and filter it to only show rows where the ID field ( on either of the tables) is not blank.

The solution I had innitially in mind is ( IF Table A[ID] not blank = 1 , IF (RELATED(Table B[ID] not blank = 1 , else 0)))

and then add this collumn as a filter to the visual selecting only those with 1. But not sure of correct syntax.

If there is a better way of doing it ?

This is the current result

TABLE A			TABLE B
ID	Name	Type	ID	Name	Type
223	1	A	223	A
224	2	B	224	B
225	3	A
226	4	B
			340	D	A
540	3	B
				V
				K
				F

This is what I would like to have

TABLE A			TABLE B
ID	Name	Type	ID	Name	Type
223	1	A	223	A
224	2	B	224	B
225	3	A
226	4	B
			340	D	A
540	3	B

Thanks

Re: DAX IF OR formula to filter NOT BLANK VALUES from Related tables

ibarrau — Mon, 27 Apr 2020 11:54:53 GMT

Hi, if you want to create that column you can do it, but I think is not necessary. You can just add the id columns to the filter pane for the visualization you want to filter, the entire page or the entire report in order to filter the id as "is not blank". Add the ids to the filter pane, both of them.

If you still want the column it can be like this:

Column = IF ( AND( ISBLANK(Table A[ID]) , ISBLANK(RELATED(Table B[ID])) ), 1, 0 )

Then you can add this as filter asking for 0 (when they are not blank)

Regards,

Re: DAX IF OR formula to filter NOT BLANK VALUES from Related tables

Anonymous — Mon, 27 Apr 2020 12:18:29 GMT

I considered the filtering option but if I Add two filters: one for TableA[ID] and 1 for Table B[ID] it would only show me results that match both criteria i.e. where both fields are not blank, and I am looking for a way to do OR between the two different fields.

I tried the formula but getting an error message Too many arguments werepassed to the AND funtion ?