Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Harxxxx
Simran 80xxxx Aarxxxx
Shyam 90xxxx Banxxx
Krish 10xxxx Carxxxx
Tom 20xxxx Darxxxx
Table 2:
Name
Ram
Krish
Tom
When I create a table visual then the output should be like this.
Name Contact Address
Simran 80xxxx Aarxxxx
Shyam 90xxxx Banxxx
I want to remove all the rows dynamically from table 1 which has the same name in Table 2.
Suggest me some way to achieve this.
Solved! Go to Solution.
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
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 !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |