Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX - Running Percentage Over Time?

 

I'm working on plotting a Percentage Over Time. I have my measures configured and working properly on a daily basis but what I would like is for a running percentage / rolling average.

 

I've attached the Table, Rate Formula, Percentage Formula and Graph. The Graph lets me know that it is doing the calculation on a daily basis instead of a rolling basis by the huge difference of today's date but the calculations are right. The Graph checks out. I just can not figure out how to make the average build over time. 

 

 

Need Help
Tutorial Requests

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    In a simple table, show the expecrted result.  Also, share the download link of your PBI file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello Ashish,

     

    I canf't share the PBI file as it contains sensitive data but the expected result would be a % that builds over time. 


    To explain better, i am looking at processed tickets. The rolled Rate is tickets that did not include review and Guidance Rate is tickets that had to be reviewed.

     

    Iam using a count filter for the two numerators and then I want to track the rates over time. Right now, it appears to be computing a percentage for each day instead of a running percentage of all values.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    If the minimum date is calculated using MINX ( ALLSELECTED ( 'Date' ), 'Date'[Date] ), does this measure give the desired output?

     

     

    Guidance Rate =
VAR STARTDATE =
    MINX ( ALLSELECTED ( 'Date' ), 'Date'[Date] )
VAR Result =
    CALCULATE (
        'RAW - ALL'[GR],
        FILTER (
            ALL ( 'RAW - ALL' ),
            'RAW - ALL'[LCRBA Approved TimeStamp] >= STARTDATE
        )
    )
RETURN
    Result

     

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.


    Best Regards,
    Winniz