Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Creating impact calculator

Hi all,   I am new with Power BI and i am trying to re-create on tool i used in Excel. It basically tells me what is an impact of one person/process to the team result. Below is table and function ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Apologies, this was a table reference

 

=($D$9-$D2)/($B$9-$B2))-$C$9

 

 ABCDE
1NameFreqResultttlsImpact
2name 1103003000-3.06131
3name 21525738550.679559
4name 376524564-21.6475
5name 4502171085027.31679
6name 543641456-3.15207
7name 624150360024.7367
8name 7233297567-13.9368
9 13326234892 

 

Hope this clarifies

regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    You can try to use follow measure if it suitable for your requirement:

    Measure = 
VAR freq_T =
    CALCULATE ( SUM ( Test[Freq] ), ALLSELECTED ( Test ) )
VAR result_T =
    CALCULATE ( SUM ( Test[Result] ), ALLSELECTED ( Test ) )
VAR tts_T =
    CALCULATE ( SUM ( Test[ttls] ), ALLSELECTED ( Test ) )
RETURN
    ( tts_T - MAX ( Test[ttls] ) )
        / ( freq_T - MAX ( Test[Freq] ) )
        - result_T

     

    Regards,
    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Xiaoxin Sheng,

       

      This does provide an idea where is the biggest impact, but what i need is to calculate exactly how many seconds that impact is.

       

      This would help me to understand a level of potential improvement.

       

      Thank you for your help

      Filarap

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        HI Anonymous,

         

        >>what i need is to calculate exactly how many seconds that impact is

        I'm not so sure for this, can you please explain more about this?(e.g expected result)

         

        Regards,
        Xiaoxin Sheng