Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Kalachuchi
Helper III
Helper III

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 function

COUNTX(FILTER('Table1','Table1'[Status]="Completed"),'Table1'[Status])
EIDStatus
1

Pending

2Completed
2Completed
3Completed

 

Output: Completed = 2

1 ACCEPTED SOLUTION
lkalawski
Super User
Super User

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

View solution in original post

6 REPLIES 6
v-easonf-msft
Community Support
Community Support

Hi , @Kalachuchi 

@amitchandak ‘s formula needs to be slightly adjusted.

Measure = COUNTX(summarize(FILTER('Table1','Table1'[Status]="Completed"),'Table1'[EID]),[EID])

 

If your problem has been solved,please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

 

Best Regards,
Community Support Team _ Eason

amitchandak
Super User
Super User

@Kalachuchi , Try like

COUNTX(summarize(FILTER('Table1','Table1'[Status]="Completed"),'Table1'[Status]),[Status])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
TomMartens
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Greg_Deckler
Super User
Super User

@Kalachuchi - Try - 

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

or

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
mohammedadnant
Impactful Individual
Impactful Individual

@Kalachuchi 

 

This will help,

 

Completed Count = CALCULATE( DISTINCTCOUNT(CompleteTable[EID]),
FILTER('CompleteTable','CompleteTable'[Status]="Completed"))
 
Thanks and hit the like button,
Mohammed Adnan
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!

Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18
lkalawski
Super User
Super User

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.