Average per row by date

Hi Boris_EmV ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Create a measure

Average = 
VAR _COUNT = COUNTROWS(ALL('Table'))
RETURN
    IF(
        ISFILTERED('Table'[COGS]),
        SELECTEDVALUE('Table'[COGS])/_COUNT,
        SELECTEDVALUE('Table'[COGS])
    )

Final output

Best regards,

Albert He

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

Hi Boris_EmV 
sorry, my bad, I made a mistake. It should of course be 

CALCULATE( COUNTROWS( Table ), ALL( Table ) )

While you could also shorten it to this:

COUNTROWS( ALL( Table ) )