Forum Discussion
Remove/Hide multiples rows dynamically from dataset
I have a dataset consisting of two tables Table 1 has all the data and Table 2 consist list of exception which should not be there in Table1 Table 1: Name Contact Address Ram 70xxxx Ha...
You can do this in Power Query of DAX
In Power Query you could merge using a right anti join.
Or create a relationshiop and create a DAX measure
exceptionflag = INT(NOT(ISEMPTY(Table2)))
this will return 1 if the Table1 has a corresponding value or null if it does not.They in your visual use the FILTER menu to only show rows with exceptionflag not = 1
Remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works. Thank you !
Anonymous
create a calculated column in table 1 to find the names presented in Table 2 exception list
lookup name = LOOKUPVALUE('Table 2'[name],'Table 2'[name],'Table 1'[name])
In table visual, drag and drop the 'lookup name' field in Filters on this visual pane and in basic filtering select blank option.
If this post helps you mark it as 'Accept as solution' below.