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] ) ) ) 
)
Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Hi Mork
I think u created calculate measure , by the way i suggest u please create column with same formula. 

See , if u using the formula which u have right now it will give total sum of measurew level then it will wotking  value.but this is now right percentage.
U try to done by row level.

Correct me if am wrong :-)