Calculating The Average in dynamic way

Hi  youssefm9 ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Slicer =
DISTINCT('Table'[Month_Year])

2. Create measure.

Client_Measure =
var _select=SELECTCOLUMNS('Slicer',"1",[Month_Year])
var _count=COUNTX(ALLSELECTED('Slicer'),[Month_Year])
var _selectsum=SUMX(FILTER(ALL('Table'),'Table'[Month_Year] in _select),[MRR])
return
IF(
    HASONEFILTER('Table'[Month]),
    [Average per Client],
    DIVIDE(
    DIVIDE(
        _selectsum ,_count),    AVERAGEX(FILTER(ALLSELECTED('Table'),'Table'[Month_Year] in _select),[Clients])))

Group_Measure =
var _select=SELECTCOLUMNS('Slicer',"1",[Month_Year])
var _count=COUNTX(ALLSELECTED('Slicer'),[Month_Year])
var _selectsum=SUMX(FILTER(ALL('Table'),'Table'[Month_Year] in _select),[MRR])
return
IF(
    HASONEFILTER('Table'[Month]),
    [Average per Group],
    DIVIDE(
    DIVIDE(
        _selectsum ,_count),    AVERAGEX(FILTER(ALLSELECTED('Table'),'Table'[Month_Year] in _select),[Groups])))

3. Result:

Best Regards,

Liu Yang

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