topic Power bi desktop in DAX Commands and Tips

Power bi desktop

manoj619 — Thu, 20 Mar 2025 13:30:39 GMT

In Power BI, I need to create a display that shows only the values from Table B that are not present in Table A, based on the selected country from a dropdown filter

Table a

Car Country

tata india

tata swiss

swift pak

benz swiss

swift India

kia pak

Byd. Lanka

Byd India

Table b

Brand year

benz 2000

kia 2001

tata 2002

Volvo 2003

example:

if i select pak in dropdown the output should be

Benz 2000

tata 2002

Volvo 2003

If i select india the output should be

benz 2000

Kia 2001

Volvo 2003

Re: Power bi desktop

bhanu_gautam — Tue, 18 Mar 2025 15:24:42 GMT

manoj619

Ensure that there is no direct relationship between Table A and Table B.

Use the 'Country' column from Table A to create a dropdown filter.

Create a new calculated table that will contain the brands from Table B that are not present in Table A for the selected country.

DAX
FilteredBrands =
VAR SelectedCountry = SELECTEDVALUE('Table A'[Country])
RETURN
FILTER(
'Table B',
NOT 'Table B'[Brand] IN
CALCULATETABLE(
VALUES('Table A'[Car]),
'Table A'[Country] = SelectedCountry
)
)

Use a table visual to display the values from the FilteredBrands table.

Re: Power bi desktop

Anonymous — Wed, 19 Mar 2025 06:27:17 GMT

Hi, manoj619

You can try the following methods.

Measure = VAR SelectedCountry = SELECTEDVALUE('Table a'[Country]) Var _table= FILTER( 'Table b', NOT 'Table B'[Brand] IN CALCULATETABLE( VALUES('Table a'[Car]),'Table a'[Country] = SelectedCountry)) RETURN IF(SELECTEDVALUE('Table b'[Brand]) in _table,1,0)

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power bi desktop

manoj619 — Fri, 21 Mar 2025 12:02:42 GMT

i got error as the number of arguments is invalid. Function containsrow must have value for each column in the table expression

Re: Power bi desktop

manoj619 — Fri, 21 Mar 2025 12:07:11 GMT

showing expression refers to multiple columns cannot be converted a scale value