Forum Discussion

viralpatel21's avatar
viralpatel21
Icon for Helper II rankHelper II
3 years ago
Solved

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

Hello   I am trying to create the  column  "dentifying" to calculate duplicates based on Multiple conditions.. i.e.    e.g. if the name has a duplicate but the match status has has "monitored" an...
Need Help
Show and Tell
Tutorial Requests
viralpatel21's avatar
viralpatel21
Icon for Helper II rankHelper II
3 years ago

Thank you for the solution. But i dont think i have correctly explained myself.

 

The identifying column is the column which i want to achieve.  

ie.e if the name has a duplicate but the match status has has "monitored" and " unmonitorted" then the identifying column should say "yes".

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi @Raghu26 ,

You can create a calculated column as below to get it, please find the details in the attachment.

Identifying = 
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Match status] ),
        FILTER (
            'Table',
            'Table'[Name] = EARLIER ( 'Table'[Name] )
                && 'Table'[Match status] IN { "Monitored", "Unmonitored" }
        )
    )
RETURN
    IF ( _count > 1, "yes", "no" )

Best Regards 

  • viralpatel21's avatar
    viralpatel21
    Icon for Helper II rankHelper II
    3 years ago

    Thank you so much!!! it worked brilliantly!!