Forum Discussion

SimonSeez2's avatar
SimonSeez2
Frequent Visitor
4 years ago

Percentage Calculate Error on Matrix Visual

Hello,    I've got this problem where my overall performance status % is incorrect (see second sub-unit) . When I review on individual line items the values are correct but the aggregated values pe...
Need Help
Show and Tell
PijushRoy's avatar
PijushRoy
Community Champion
4 years ago

Hi SimonSeez2 

Try this and comment
Call Report Completion % = 'Customer List '[Call Rep Count] / ALL('Customer List '[Total Count])

SimonSeez2's avatar
SimonSeez2
Frequent Visitor
4 years ago

Hello PijushRoy 

 

Thank you responding. 

 

I tried your suggestion but I get the red wavy line with message "parameter is not the correct type" underneath Customer List '[Total Count]

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    SimonSeez2 , If these are columns then you should % like

    Call Report Completion % = divide(sum('Customer List '[Call Rep Count] ) , Sum( 'Customer List '[Total Count])  )

     

    If the are measures

     

    Call Report Completion % = divide(,[Call Rep Count] ,'[Total Count],0)