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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Issues with having a right formula

I am trying to get the right subtotals and total averages in the utilisation matrix report I am creating. I am using this DAX: IFERROR(IF(ISINSCOPE('X'[Y]),[sum]/[count],[Utilisation]),BLANK())
I have different type of utilisation, and for some reason the results that it provide in both are the same and I am not sure why the "sum" formula does not provide the right infromation I need.
sum = SUMX(Table, Utilisation)
#Thank you
Frequent Visitor

So I have Practice on top, then group and the resource, divided by months. But my matrix has some blanks on the resources, so I want that the subtotals for Group and Practice has the right average of utilisation ignoring the blanks.


Something like this:




Is that something you have reviewed in the past?


Please try

using Utilisation_Product =
AVERAGEX ( VALUES ( 'X'[Y] ), COALESCE ( [Utilisation], 0 ) )
Super User
Super User

Hi @alexacg 

if Utilisation is a measure tye

sum = SUMX ( VALUES ( 'X'[Y] ), [Utilisation] )

Hi Tamerj1, thank you so much for your help on this :). That definitely solved my sum formula, but it did not fix my error on the matrix to average correctly the product and subproduct categories I have ignoring the blanks, and I was using Utilisation_Product= IFERROR(IF(ISINSCOPE('X'[Y]),[sum]/[count],[Utilisation]),BLANK()), any idea about this?


How does your matrix look like? What columns are placed in the matrix? What results are you expecting?

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors