cancel
Showing results for
Did you mean:

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

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