How to Find and Count Unique and Duplicate Values Based on Multiple Conditions in Power BI

Power BI Tutorial for beginners on how to find and count unique and duplicate values using the DAX function which can lead to creating actionable analytics in power bi reports and dashboards using simple table visualization or matrix visualization or slicer.

[snehaify]

Superb! Exactly what i was looking for. Thanks.

[hussainshaik]

Awesome!! This is what I wanted to find out and this is the video helped me to fix it. Thank you. I'm looking for more videos like this as I just have subscribed your channel 👍.

[jaspreetsingh-jlob]

Thank you for sharing. I am having 1 problem where in two column values are the same but still while creating such dax it is showing as different.
E.g
column 1 = 20
Column 2 = 20
Dax to compare these two columns using if condition is showing as false.

[AkhtarHussain-cthr]

Very informative - Thanks, we have equipments with multiple work orders (work order could be same or different - depends on time period), these equipments break down, I want to find out how many times an equipment broke down within a specific time period. How can I do that?

[azeezmain]

Bhai,

By using earlier function I am getting distinct count of product name when I applied earlier function in category but when I see overall distinct count for the same dax it is different can you please help me to achieve both the distinct criteria meet in one dax

[PhillipLearnTeach]

I have 2 columns where one is ID and other are values.The other column has some values that are the same, problem is ID on left can have same xxx for 2 of them and xxy for 3 of them and even xxU for 7 of them. How? Subscribed. Thanks a lot.

[vinodkumarhs]

Can we use this formula for created measures

[ARUNPK-jbmk]

Hi this video helped, how to find in less value in duplicate as same list

[rishabhmahajan]

Sir, how to do this thing if earlier(category) not = category. Btw your content is great. Thank you

[maheshgupte]

Dear Abhishek,
I am trying to use this same but it is not working for me
Unique Task = COUNTROWS(FILTER(WorkFlow_Planner_task, EARLIER(WorkFlow_Planner_task[value.title] =
Need your help can please ley me know if I am making any error

"Error : The first argument of EARLIER/EARLIEST is not a valid column reference in the earlier row context.

[mohd_ashh]

How can we solve this question?

Link of the Data set -

- What is the percentage of customers who are repeating their orders? Are they ordering the same
products or different?

- For the repeat customers, how long does it take for them to place the next order after being delivered
the previous one?