Forum Discussion

dana1's avatar
dana1
Frequent Visitor
9 years ago

RANK&CALCULATE SOS!

Hey,
, everything I've tried so far does not work :(
I have a table that contains the customer calls to the call center. 
Each customer has an institutions ID so you can see from which institute he is contacting us. I need to count the number of calls for each institute in 2016 and then rank the institute,
so that only the 120 institutions with the most calls to the call center will be shown. The next step, is to present the amount of calls in 2017 of the same 120 institutions (i need to compare 2 years) The next step is to calculate the target- X = the number of calls of 120 institutions with the most calls for 2016 Y = the number of calls of the same 120 institutions in 2017
(X-(X*0.2))/Y I managed to produce all of these in the table,
but I need to present a KPI visual which will show me only the calulation I've been dealing with it for over a week and I can not find a solution. Really needs help!



 

4 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    dana1

     

    Hi, can you please post sample data or Test Pbix.

     

    Regards

     

    Victor

    Lima - Peru

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi dana1,

     

    From above image, it looks like you have received desired result returned by (X-(X*0.2))/Y for each instituteID. So, what did you mean "I need to present a KPI visual which will show me only the calulation"? How do you want to display value on KPI? Could you please illustrate your requirement with an example?

     

    Regards,
    Yuliana Gu

     

    • dana1's avatar
      dana1
      Frequent Visitor
      I solved the problem!
      thanks anyway :)
      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee

        Hi dana1,

         

        Glad to hear that you have resolved it. Would you please kindly share your solution with us? And Please kindly mark it as an answer so that others having similar problem can find the solution more easily.

         

        Regards,
        Yuliana Gu