Forum Discussion

jochendecraene's avatar
jochendecraene
Helper V
4 years ago

Wrong average when summarized

Hi

 

I've calculated an occupation rate of some rooms.

That works fine per year, but it gives me the wrong  grandtotals ...

I've made this measures: 

 

Global month = Ms_Global[ms_Registered_Rooms]/Ms_Global[ms_Max_Rooms_Year]

 

Global_Average = AVERAGEX(SUMMARIZE(d_Calendar,d_Calendar[Year],d_Calendar[Month],"_1",[Global month]),[_1])
 
Can someone help me out?
 

 

Need Help
Show and Tell

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    Hi jochendecraene ,

     

    Measure is calculated based on the current row context. Please share the sample data and all measures involved in the formula, so that we can know your scenario better.


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