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! 😀

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey Kalachuchi ,

 

wondering if this more simpler measure is sufficient:

Measure = 
CALCULATE(
    DISTINCTCOUNT('Table'[EID])
    , 'Table'[Status] = "Completed"
)

Hopefully, this provides what you are looking for.

 

Regards,

Tom