Forum Discussion

Kalachuchi's avatar
Kalachuchi
Helper III
6 years ago
Solved

Working with Count,summarize and filter

So I have a column EID and status,   I only want to filter the completed and summarize it based on EID and after will count the rows. I got lost here don't know where would I put the summarize fun...
General Comment
Need Help
Tutorial Requests
  • lkalawski's avatar
    lkalawski
    6 years ago

    Hello @Kalachuchi

    You can use this measure to get different EID values:

    Cnt of Completed = CALCULATE(DISTINCTCOUNT('Table'[EID]),FILTER('Table','Table'[Status] = "Completed"))



    _______________
    If I helped, please accept the solution and give congratulations! 😀

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Kalachuchi - Try - 

Measure = COUNTROWS(DISTINCT(FILTER('Table1','Table1'[Status]="Completed")))

or

Measure = COUNTROWS(SUMMARIZE(FILTER('Table1','Table1'[Status]="Completed"),[EID]))