Power BI DAX Function To Find Unique or Duplicate Values in Power BI

Power BI Tutorial on how to find unique or duplicate values in a dataset, also you will see that how many times a particular value is appearing in a dataset.

[alifarooq]

Thanks for the tutorial spreadsheet, stay blessed.

[SathishKumar-oqtz]

In a table or a matrix, I have count of 3 as qty and under 3 below row, how do I get 3 corresponding product I'd in power bi.

[rajarshi]

I am trying to create a new column where only unique order ID are present duplicates are blank I want this calculation done based on sales only the max sales order ID should be considered, Is it possible to do so ?

[Jay-ojcd]

Is there a way to find duplicates in measures? like EARLIER()?, thing is, i have a date slicer and i want to find the duplicates within the [slicer date] and [slicer date] - 30 days

[koteswaribapatla]

Hi sir, i was done merging two tables, out of 1000 rows i got 500 rows are common when I do innerjoin but while loading power bi and doing refresh 1000 rows are loaded then it's taking more time to refresh so how to resolve this i want to refresh only 500 rows

[dandane]

Could you explain why it is necessary to sort?

[hendrikbartels]

Where do I find the link to your excel sheet ? Thanks