Forum Discussion

VanNostrand's avatar
VanNostrand
Regular Visitor
3 years ago
Solved

Trouble Calculating Percentage Difference

Hi guys, I'm just starting PowerBI and I'm facing an issue for several days that can't seem to overcome. In my data set I have two tables: "Plans" and "Actuals". Within the table "Plans" there's a ...
Need Help
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    wrap the sum functions in a calculate function to change the context

     

    e.g. OverCost = CALCULATE( SUM (Actuals[ActualCosts])) - CALCULATE(SUM (Plans[PlannedCosts])) / CALCULATE(SUM (Plans[PlannedCosts]))

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

wrap the sum functions in a calculate function to change the context

 

e.g. OverCost = CALCULATE( SUM (Actuals[ActualCosts])) - CALCULATE(SUM (Plans[PlannedCosts])) / CALCULATE(SUM (Plans[PlannedCosts]))

  • VanNostrand's avatar
    VanNostrand
    Regular Visitor
    3 years ago

    Thanks indeed with the CALCULATE function worked. 
    But in the same table "Plans" I tried to apply the same formula for something equal, which is the projects in over duration. There's another table named "Actual_Duration" that states the values in the column 'ActualDuration'.

    OverDuration = (CALCULATE( SUM (Actual_Duration[ActualDuration])) - CALCULATE(SUM (Plans[PlannedDuration]))) / CALCULATE(SUM (Plans[PlannedDuration]))

    Error: A circular dependency was detected: Plans[Column], Plans[OverCost], Plans[Column].