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 per sub-unit on the Matrix is wrong. Please see "Call Report Completion %" also for the second sub-unit 

 

Call Report Completion % = 'Customer List '[Call Rep Count] / 'Customer List '[Total Count]
Overall Performance Status= IF('Customer List '[Business Unit Check] = 0, 'Customer List '[Call Report Completion %], 'Customer List '[Overall Status])

 

I'm expecting the value for the second sub-unit to be 85%

 

 

Thank you 

 

Need Help
Show and Tell

4 Replies

  • 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)