Group,Filter,Count

[Kalachuchi]

Supplied = COUNTX(FILTER('List','List'[Completeness]="Supplied"),'List'[Completeness])

EID	Completeness
1	Supplied
2	Not Supplied
1	Supplied

I have the code above but  I want to count them by grouping the rows who has  same EID.

Result would be: EID 1 = 2 counts of supplied
EID 2 = 1 count of Not supplied

[amitchandak]

@Kalachuchi , what is the problem tehse two measures should work

Supplied = COUNTX(FILTER('List','List'[Completeness]="Supplied"),'List'[Completeness])

Not Supplied = COUNTX(FILTER('List','List'[Completeness]="Not Supplied"),'List'[Completeness])

[Kalachuchi]

@amitchandak I think its counting duplicates, I want to group it first before counting with filter.

[v-deddai1-msft · Accepted solution]

Hi @Kalachuchi ,

Would you please try to use the following summary table:

Table 2 = SUMMARIZE('Table','Table'[EID],'Table'[Completeness],"_count",COUNT('Table'[Completeness]))

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

Best Regards,

Dedmon Dai