Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
General Comment
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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
    )
)
amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    Thankyou for replying.