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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
dineshpj
New Member

Pregunta de Countif

Soy nuevo en powerbi y necesito ayuda para convertir la siguiente fórmula de Excel a una expresión

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

1 REPLY 1
Anonymous
Not applicable

Hola @dineshpj ,

Cree una medida como se muestra a continuación:

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


Saludos
Kelly
¿He respondido a tu pregunta? ¡Marca mi puesto como una solución!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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