Forum Discussion

dineshpj's avatar
dineshpj
New Member
6 years ago
Solved

Countif Question

I am new to powerbi and I need help in converting the below excel formula to an expression 

 

=IF(AND(COUNTIF(D:D,[@Number])>1,COUNTIFS(E:E,"*Response*",D:D,[@Number])>1),"Duplicate","No")

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi dineshpj ,

     

    Create a measure as below:

     

    measure =
VAR _count1 =
    CALCULATE (
        COUNT ( 'Table'[Column D] ),
        FILTER ( 'Table', 'Table'[Column D] = [@Number] )
    )
VAR _count2 =
    CALCULATE (
        COUNT ( 'Table'[Column E] ),
        FILTER (
            'Table',
            'Table'[Column E] = "*Response*"
                && 'Table'[Column D] = [@Number]
        )
    )
RETURN
    IF ( _count1 > 1 && _count2 > 1, "Duplicate", "No" )

     

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi dineshpj ,

     

    Create a measure as below:

     

    measure =
VAR _count1 =
    CALCULATE (
        COUNT ( 'Table'[Column D] ),
        FILTER ( 'Table', 'Table'[Column D] = [@Number] )
    )
VAR _count2 =
    CALCULATE (
        COUNT ( 'Table'[Column E] ),
        FILTER (
            'Table',
            'Table'[Column E] = "*Response*"
                && 'Table'[Column D] = [@Number]
        )
    )
RETURN
    IF ( _count1 > 1 && _count2 > 1, "Duplicate", "No" )

     

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!