Distinct Count with text column condition

[Anonymous]

Hi,
How can I count the Distinct number of cases where the count of "Yes"is > 1

Case no	Yes Column
12
12
12	Yes
13
13	Yes
13	Yes

Count of Cases = CALCULATE(DISTINCTCOUNT('Table'[Case no]),FILTER('Table','Table'[Yes Col] = "Yes"))​

I can calculate the number of cases but i don't want the cases with only one "Yes". So from the above table it should skip case no 12 and should give answer as 1 i.e caseno 13

Thanks!!

[Mahesh0016]

Hello,
Good monrning,
i think above two solutions in one of the solutions useful for you.

[Anonymous]

Thankyou for replying.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

expected result measure: =
COUNTROWS (
    FILTER (
        DISTINCT ( 'Table'[Case no] ),
        CALCULATE ( COUNTROWS ( FILTER ( 'Table', 'Table'[Yes Column] = "Yes" ) ) ) > 1
    )
)

[Anonymous]

Hi,

Thankyou. This measure works the best.

Regards,

Shubham

[amitchandak]

@Anonymous , have these two measures

measure 1= calculate(count('Table'[case no]),FILTER('Table','Table'[Yes Col] = "Yes"))

Measure
count GT 1 = countx(values('Table'[case no]), if([measure 1]>1, [case no], blank()))

[Anonymous]

Thankyou for replying.