Forum Discussion

manoj619's avatar
manoj619
Regular Visitor
1 year ago

Power bi desktop

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...
power bi
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • manoj619's avatar
    manoj619
    Regular Visitor
    1 year ago

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