How to find the YTD Average based on month wise data

[sivadoss87]

Hi All,

I have a monthwise coverage value for the divisions and have a group coverage value highlighted in green.  

The monthwise covearge values for all the divisions to be summed up(15.66+22.50+20.76+25.97=84.89) and divided by the group coverage value (84.89/84.91)and calculating the AVG coverage value (for 2017-01, (84.89/84.91) =100% .pls see the below Coverage AVG),  finally i have to find the YTD Avearge . its a average of all the months coverage AVG

Please tell me how this can be achieved by DAX . Thanks in advance.

Regards,

P.Kalidoss

[v-ljerr-msft]

Hi @sivadoss87,

Have you tried the solution provided by @Greg_Deckler? Does it work in your scenario?

If it works, could you accept it as solution to close this thread? If you still have any questions, feel free to post it here. 

Regards

[Greg_Deckler · Accepted solution]

Is the Group number just a static value?

Looks like you would want to import your top table, Month, Div1, Div2, Div3, Div4 although you might want to import it as:

Month,Division

2017-01,15.66

2017-01,22.50

2017-01,20.76

2017-01,25.97

...

Then you could create a measure like:

Grand Total = SUM([Division])

If your Group is in its own table, you could create a measure:

Measure = Table1[Grand Total] / Table2[Group]

You would need another table for your bottom table and could do a simple average of the values.