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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
scorbin
Helper I
Helper I

Why can't I use this summarize measure as a row in a matrix for getting counts over time?

I am trying to use a summarize measure that looks at another measure as a row in a matrix and I am not sure why it is not allowing me to do that. The matrix rows consist of data including Area, Location, Job, and Employee Name. The columns are the week number and the values are the Count of Employees. Basically I am trying to get the count of employees over time under those labels. I get the intended results when viewing the data in a table, but I need to see it in a matrix. The measure being evaluted in the summarize measure looks like this: 

Billed Hours Prct = [SumBilledHours] / [SumTotalHours]

I then take that measure and put it in a summarize function: 

Over 90% Billed = SUMMARIZE(HoursTable, "Over 90% Billed", IF(HoursTable[Billed Hours Prct] < .9, "Less Than 90%", "More Than 90%"))

Should I be doing something else besides summarizing in order to get the data organized that way in a matrix? 

 

3 REPLIES 3
vanessafvg
Super User
Super User

maybe i dont quite understand what you are asking, please provide some sample data with your expectation of what you are trying to achieve.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




vanessafvg
Super User
Super User

you need to aggregate your measure,  the if statement isn't an aggregation.  You want to sum the result of the if statement.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




How would I sum the result of the IF statement if the results are strings? Or would there be a different aggregate I should use? 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.