Forum Discussion
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...
bhanu_gautam
Super User
Super UserEnsure 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.
showing expression refers to multiple columns cannot be converted a scale value
