cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

% 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

 

1 REPLY 1
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,

Dale

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.