Forum Discussion
Help with DAX formula
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] ) ) ) )
Chargeability2 and Chargebility1 is a percentage. My numbers are random that's why you get 200% in chargeability2.
Try putting chargeability2 in a card in order to show the chargability of all the resources together. It gives me a really low percentage when it should give the average of the chargability percentage of each resource. And when I choose a single resource from a slicer the card shows the correct percentage.
Using your data, I get 2.49 in my card, which matches the Total column in the table...?
Ok just noticed that your chargeability2 formula is not like the one I posted. You are actually multiplying after the division while I multiply inside the division. You have misplaced a parenthesis.
I want to multiply the capacity with the expected chargability.
Actually now that I did some calculations even when I select a single resource the percetage isn't correct.
For example if I multiply the capacity of one resource with its expected chargeability and divide the the chargeable by that number then I get a number different from the one my formula is giving me. I want to perform the above calculation for all my resources and also be able to filter it by resource.
Hi,
Could you please provide the expected result - I don't see how the sum of all the Expected values will make sence on the Total level.