Forum Discussion
Total Average with Filter Context
Hi, I´m having problems to calculate a total average when I use filter context. I have this TABLE 1 : I need to group X and Y, because they are the same ml Model, so i ve created the ML GROUPED ...
amitchandak
Super User
Super Usertomasbaleriani , If you want a simple avg of Avg (the sum of the divide)
You need measure like
AverageX(Values(Table1[ID]), calculate(divide( [SALES] , [CALLS]) ) )
where [SALES] and [CALLS] are measures