Forum Discussion

michael_knight's avatar
michael_knight
Post Prodigy
5 years ago
Solved

Duplicate detection, return a value

Hi,   I'm trying to create a column which will display an outcome depending on the results of the duplicate detection   This is sample data that I'm working with   This is the outco...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try this column expression to get your result.

     

    HalfFull =
    VAR agentcount =
        CALCULATE (
            DISTINCTCOUNT ( 'Table'[Agent] ),
            ALLEXCEPT ( 'Table', 'Table'[Address], 'Table'[Status], 'Table'[Company] )
        )
    RETURN
        IF ( agentcount = 1, "Full", "Half" )

     

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Please try this column expression to get your result.

 

HalfFull =
VAR agentcount =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Agent] ),
        ALLEXCEPT ( 'Table', 'Table'[Address], 'Table'[Status], 'Table'[Company] )
    )
RETURN
    IF ( agentcount = 1, "Full", "Half" )

 

Pat

 

michael_knight's avatar
michael_knight
Post Prodigy
5 years ago

Thank you, Pat!