Get list of rows that has different values for a specific column

[Jagan_MFilterIT]

Hi, 

I am not able to figure our this speciifc Dax problem and need communities help. 

Sample data below where we have data for products by City :

Basically row highlighted in red are cities where the price is different for a given day. The solution required is to return a matrix like below 

List of cities where prices differ between rows. Can you please guide me on the Dax for this? 

[ryan_mayu · Accepted solution]

@Jagan_MFilterIT 

you can create a column

Column = 
var _price=maxx(FILTER('Table','Table'[date]=EARLIER('Table'[date])&&'Table'[productcode]=EARLIER('Table'[productcode])&&'Table'[City]=EARLIER('Table'[City])&&'Table'[City Price]<>EARLIER('Table'[City Price])),'Table'[City Price])
return if(ISBLANK(_price),"N","Y")

pls see the attachment below

[v-cgao-msft · Accepted solution]

Hi @Jagan_MFilterIT ,

Please create a new measure and apply it to the filter for this vision and set it up as shown in the figure.

Measure = DISTINCTCOUNT('Table'[City Price])

The PBIX file is attached for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Jagan_MFilterIT]

Thannks much! This logic simply didt strike me at all! 

[ryan_mayu · Accepted solution]

@Jagan_MFilterIT 

you can create a column

Column = 
var _price=maxx(FILTER('Table','Table'[date]=EARLIER('Table'[date])&&'Table'[productcode]=EARLIER('Table'[productcode])&&'Table'[City]=EARLIER('Table'[City])&&'Table'[City Price]<>EARLIER('Table'[City Price])),'Table'[City Price])
return if(ISBLANK(_price),"N","Y")

pls see the attachment below