Forum Discussion
DAX Code that pulls out values when they differentiate between columns
Is there a way to to pull out rows that have a duplicate value in one column but different value in another column So when I load this dataset into PowerBI, I want to to pull out IDs 1 a...
amitchandak
Super User
Super UserAnonymous , Output you want is not clear. This measure with id column should give you 1,3
countx(filter(summarize('Data', 'Data'[ID] , "_1",COUNTA('Data'[ID])) ,[_1]>1),[ID])