Only Show rows where there are matching values

[JenWilson]

Below is an example of a table visual I am working on in PBI. I am trying to display the tables where the data is coming from (there are 3 tables which do have relationships. Customers table to Sales Table (one to many), Product Table to Sales Table (one to many). 

What I am looking to do, is only display a single row when the values from the column "Product Table Level" match the values from the Customer Table Level".  In the screen shot below, the first table represents how the data is currently being displayed. The second table is the desired result. Is there a dax formula that I can use to filter this table down to the desired result? Thank you! 

[NaveenGandhi · Accepted solution]

HI @JenWilson 

Use below measure and apply it as a visual filter.

Filter = if(SELECTEDVALUE('Table'[Product Table Level])=SELECTEDVALUE('Table'[Customer Table Level]),1,0)

Let me know if this works, I have this solution assuming things are simple. If this does'nt work or data model is complicated, please provide a sample file or more details.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[rajendraongole1]

Hi @JenWilson - can you try below calculated colum to filter down to the desired result

Matched Level =
IF(
RELATED('Product Table'[Product Table Level]) = RELATED('Customers'[Customer Table Level]),
RELATED('Product Table'[Product Table Level]),
BLANK()
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!