Sum of a Calculated measure

[EmaVasileva]

Hi team,
I try to get the sum of rows of my last column, which is calc measure.  

Year	Month	Hours	Days in month	Days in month*1.5+Hours	1-(ColumnE/(ColumnD*24)
2024	January	59	31	105.5	85.82%
2024	February	39	29	82.5	88.15%
2024	March	42	31	88.5	88.10%
2024	April	33	30	78	89.17%
2024	May	67	31	113.5	84.74%
2024	June	21	30	66	90.83%
2024	July	61	31	107.5	85.55%
2024	August	81	31	127.5	82.86%
2024	September	92	30	137	80.97%
2024	October	21	31	67.5	90.93%
2024	November	227.5	30	272.5	62.15%
2024	December	125	31	171.5	76.95%

I need the average sum (%) of the last column.

Currently 'm using a couple of measures, but the total of the column which I received is not correct (11%) and I need 85%
I have Year,month, Hours-as a columns. 
DaysInMonth calc column = DAY(EOMONTH('test'[testdate].[Date], 0))
Days in month*1.5+Hours measure= AVERAGE(pmforecast[DaysInMonth2])*1.5+ sum(plan[taskduration])
LastColumn measure = 1 - Days in month*1.5+Hours/AVERAGE(DaysInMonth)*24

Thank you.

[Fowmy]

@EmaVasileva 

Use this meaure: Replace table name and column names as per your model.

New Measure = 
AVERAGEX(
     Table11,
    VAR __DaysInMonth =  Table11[Days in month] * 1.5 + Table11[Hours]
    VAR __Result = 1 - DIVIDE(__DaysInMonth, (Table11[Days in month]  * 24 ) )
    RETURN
        __Result
)

[EmaVasileva]

Hi @Fowmy ,
Thank you for the measure! I just tried it, and it works row by row, but in the end where I need to see the average of all percentages (last column) it gave me 31.53%, when the result should be 83.85%. Any ideas how I can fix it?

[Fowmy · Accepted solution]

@EmaVasileva 

It worked for me, make sure you have no filters applied:

My table

[VijayP]

@EmaVasileva 

Question is confusing! Whether you are talking about column in a Table (Query Table) or A Measure

Column and Measure are not same that is my question.

The above table what you have shown as an example is a visual in Power BI or A Table in power bi?