DaX Help

[Syndicate_Admin]

Good.

Greetings to all.

I have a problem with a productivity calculation matrix that basically visualizes how much a worker produces per hour worked/day/week. The measure of the calculation per worker works perfectly but I do not know how to calculate the total productivity of all users since the matrix vertically is totaling them. Basically I have the calculation horizontally but not vertically or the general total.

Help please!!

[v-kkf-msft]

Hi @Syndicate_Admin ,

Please try ISFILTERED function, like this measure.

Total = 
IF (
    ISFILTERED ( 'Table'[Nombre] ),
    [SumValue],
    AVERAGEX ( VALUES ( 'Table'[Nombre] ), [SumValue] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.