Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago
Solved

Help with DAX formula

Hello all, I have two tables. One with my resources like bellow.   ResourceName           ExpectedChargeability      Resource1                          0.9      resource2                        ...
Need Help
  • sdjensen's avatar
    sdjensen
    10 years ago

    Sorry I was a bit too fast.. I tried to recreate your model and this formula seem to work for me... My table names might be different than yours...

     

    DIVIDE( 
	SUM(Capacity[ChargeableWork]); 
	SUMX(Capacity; CALCULATE( SUM( Capacity[Capacity] ) ) * CALCULATE( SUM( ExpChargeability[ExpChargeability] ) ) ) 
)
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

Try this:

 Medida 5 =

AVERAGEX (
    DetailsByResource;
    DIVIDE (
        CALCULATE ( SUMX ( DetailsByResource; DetailsByResource[ChargeableWork] ) );
        CALCULATE (
            SUMX (
                DetailsByResource;
                DetailsByResource[Capacity] * RELATED ( Resources[ExpectedChargeability] )
            )
        )
    )
)