Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dineshpj
New Member

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")

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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!

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.