Forum Discussion
Distinct Count with text column condition
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 = CAL...
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 ) )
Hello,
Good monrning,
i think above two solutions in one of the solutions useful for you.
Thankyou for replying.