Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    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 !

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

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 !