Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ) )
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?
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |