Forum Discussion

Kalachuchi's avatar
Kalachuchi
Helper III
5 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
    5 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! 😀

mohammedadnant's avatar
mohammedadnant
Impactful Individual
5 years ago

Kalachuchi 

 

This will help,

 

Completed Count = CALCULATE( DISTINCTCOUNT(CompleteTable[EID]),
FILTER('CompleteTable','CompleteTable'[Status]="Completed"))
 
Thanks and hit the like button,
Mohammed Adnan