Always getting 100% when I calculate percentage using two measures

[Anonymous]

Measure:

% critical updates = 'Update'[Total_critical_updates]/countx(ComputerUpdate,[Computer Software Update Count])*100

Result

[dedelman_clng]

COUNTX iterates over each row the entire table. I think you're looking for COUNTA or COUNTROWS. Hard to tell without a sample data set and code for [Computer Software Update Count].

Also, rather that multiply by 100 in the measure code, just format it as percentage (look on the "Modeling" tab for the % button).

Hope this helps

David