Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Average calculation

Hi All, I have a requirement to calculate the average for my data as below. Directly using the average is not giving me the right results. Data is: Requirement is to calculate the average of "#...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    There is no problem with your formula.  It's just that your measure doesn't get the right compute context for it. How did you filter you table? If you filter it in query editor, it will show like what you want.

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

 

You might need Net Work Days here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sample data attached, Can someone please help on fixing this.