Forum Discussion

user900's avatar
user900
Icon for Helper II rankHelper II
5 years ago

Using Average

I have two data sources. One includes Incident detail, the other system detail. I created a relationship between them as both have  system name and code identifiers. I have the following measures:  ...
Need Help
user900's avatar
user900
Icon for Helper II rankHelper II
5 years ago

2.56% is the sum of monthly results (0% + 0.85% + 1.71%) because I've been asked to calculate the results monthly, but to create thresholds quarterly using the sum. I'm not sure I agree with this approach vs your suggestion of 4/117 = 3.41% but I'm losing my argument unless I have more rationale behind my reasoning of that's how it should be done.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, user900 

 

Could you share some example data and draw a simple picture to show your expected visual so that i may work out with a workaround?😀

 

 

Best Regards,
Community Support Team _ Zeon Zheng

  • user900's avatar
    user900
    Icon for Helper II rankHelper II
    5 years ago

    Here is a sample of data. It shows the monthly results and the quarterly results. The quarterly results are the data points on my visual. I need the monthly to create tolerance limits which are based on historical data.

    Date# of sys w. Inc not meeting SLA# of systemsmonthly % of systems w. Inc not meeting SLAquarterly
    19-Apr1118  0.0085 
    19-May1117  0.0085 
    19-Jun4117  0.0342  0.0512
    19-Jul4117  0.0342 
    19-Aug6117  0.0513 
    19-Sep1117  0.0085  0.0940
    19-Oct1116  0.0086 
    19-Nov2116  0.0172 
    19-Dec2116  0.0172  0.0430
    20-Jan3116  0.0259 
    20-Feb0116  0.0000   
    20-Mar1116  0.0086  0.0345
    20-Apr0117  0.0000   
    20-May1117  0.0085 
    21-Jun2117  0.0171  0.0256
    • v-angzheng-msft's avatar
      v-angzheng-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, user900 

       

      I have no relevant experience with this user case and am not sure I understand your needs, do you need to create a quarterly percentage accumulation, if so then try to create the following measure

      _quarterly = CALCULATE(SUM('Table'[monthly % of systems w. Inc not meeting SLA]),DATESQTD('Table'[Date]))

      .Result:

      Best Regards,
      Community Support Team _ Zeon Zheng
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.