DAX to compare rows combination

[Anonymous]

Hi Community,

Following is a snippet of my sample dataset (that has data quality issues):

I want to compare Apnt date rows and apnt type rows combination. If there is a match then only distinct values are considered in the resultset.

So, with the right calculated column, the result would look like this:

Many thanks in advance!

[Anonymous]

Following is a snippet of my sample dataset (that has data quality issues):

I want to compare Apnt date rows and apnt type rows combination. If there is a match then only distinct values are considered in the resultset.

So, with the right calculated column, the result would look like this:

Many thanks in advance!

[Anonymous]

@Anonymous 
First you need to fill down the  case id and client id, then create a distinct table (table = distinct(table)), or just add the the column in a table visual (don't summarize).

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@Anonymous  thanks for replying, regarding this issue I have posted a new question with better dataset and samle pbi file. Please check: Compare row combinations - Microsoft Power BI Community

[amitchandak]

@Anonymous , Is the above your data format, or you have put that into a matrix.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Create a table with distinct or delete duplicates in power query

example 

New table = Distinct(Table)