Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
5 years ago

total % is wrong

Dears,

 

please i need your support for the total % (see below Table). it shows 678% why it should be 97%. how can i solve this issue please ?

The measure i used is:

% Closure = sumx(Sheet3,Sheet3[done]/Sheet3[target])

 

br,

 

Need Help

1 Reply

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi Zakaria_1980 

    you can do it like this:

     

    % Closure = DIVIDE(SUM('Table'[done]),SUM('Table'[target]))

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)