Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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?
maybe i dont quite understand what you are asking, please provide some sample data with your expectation of what you are trying to achieve.
Proud to be a 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.
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?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.