undefined

[0134ss]

How to find Average YTD percentage using Dax 

[Anonymous · Accepted solution]

Hi  @0134ss ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _today=TODAY()
var _avgYTD=
AVERAGEX(
    FILTER(ALL('Table'),'Table'[Date]>=DATE(YEAR(_today),1,1)&&'Table'[Date]<=_today),[Value])
var _avgall=
AVERAGEX(
    ALL('Table'),[Value])
return
DIVIDE(_avgYTD,_avgall)

2. Result:

If the above results do not meet your expectations, you can express the expected results in the form of a picture, we can better help you!

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