Forum Discussion

mork's avatar
mork
Helper 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] ) ) ) 
)
sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Could you try with 

 

DIVIDE( SUM([ChargeableWork]) ; SUM([Capacity]) * CALCULATE(SUM(Table1[ExpectedChargeability])))
mork's avatar
mork
Helper V
10 years ago

sdjensen unfortunatelly nothing changed.

  • sdjensen's avatar
    sdjensen
    Solution Sage
    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] ) ) ) 
)