Forum Discussion

MasterSonic's avatar
MasterSonic
Helper IV
3 years ago
Solved

Count if Filter help

Hi guys, the help I need is based on following logic: I want to find all Test, where value is OK for Task and they have same Code. As you see In the table Code is repetitve(result of unpivoting)...
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi MasterSonic 

    Thanks for reaching out to us.

    please try this

    sample data

    isduplicate = 
var _count=COUNTROWS('Table')
return if(_count>1,MIN('Table'[Code]))
    Measure = 
var _t= FILTER('Table',[isduplicate]<>BLANK())
return COUNTX(DISTINCT(_t),[Code])

    result

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

MasterSonic's avatar
MasterSonic
Helper IV
3 years ago

I try to sort it other way - can you help with this:

I have created measurement:
Distinct Count Attributes = CALCULATE (DISTINCTCOUNT(CleanTable[Task]))

this one five me count of 15
 
I have added SumColumn in power query which summarize columns.

 
I would like to get measurement: (deduction)
Distinct Count Attributes - SumColumn