Showing results for 
Search instead for 
Did you mean: 

% Complete Measure

The % Complete to Written Unit Goal is calculating wrong. 


It should be [All Units] 37264 /[Written Unit Goal] 40903


I have these measures:


All Units =

[Total_UnitsA] + [Total_UnitsB]


Written Unit Goal = 

(CALCULATE(SUM(PlanTable[Plan#]),SP_MetricPlan[UnitType] = "A")
+(CALCULATE(SUM(PlanTable[Plan#]),SP_MetricPlan[UnitType] = "B")))


[Total_UnitsA]  = 

CALCULATE(SUM('FactTable'[Value]), 'FactTable'[UnitType] = "A")


[Total_UnitsB]  = 

CALCULATE(SUM('FactTable'[Value]), 'FactTable'[UnitType] = "B")



The current measure I have for the card is 

% Complete to W.Unit Plan =

[All Units]/[Written Unit Goal]


..but the outcome is incorrect 


%complete help.JPG


Community Support Team
Community Support Team

Re: % Complete Measure

Hi @ThePowerBIQueen,


It seems all are in Card visuals. They should work. I would suggest you check them again. You posted the formula of [% Complete to W.Unit Plan] here while the [% Complete to Written Unit Goal] is wrong. 

Can you share a file or a sample please?


Best Regards,


Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.