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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
msc123
New Member

SUM Calculation of a Measure

I am using a measure to calculate the "count" of people that have achieved over 50% completion rate: 

 

.Count of 1 for people >50% = if([.Completion Percentage by Person]>.5,1,0)
 
I need to be able to summarize the "count" - and divide by the target, based a location that is set-up as a slicer.  I cannot find anything that allows me to summarize a measure, vs. a column.  I am very new to PBI and writing measures so any support would be appreciated. 

 

1 REPLY 1
AlexisOlson
Super User
Super User

One way to do this would be to sum over each distinct person. It might look something like this:

 

SUMX (
    DISTINCT ( Table1[Person] ),
    IF ( [.Completion Percentage by Person] > .5, 1, 0 )
)

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.