why the average function is not working ?

[clarafff]

Hi Guys, could you help me check what is the problem, my average function is not working on the report. No matter I use the average function on the visualisation field or write the Dax.I want to count the monthly average active users. But it just shows ' 1 ' on the result. what kinds of reasons could be ? I have checked the data type, filters ...I don't know why it is like that....Any expert could give me some guidances?

here is the test file Active users.pbix - Google Drive

[Ahmedx]

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[Ahmedx]

pls try this

act = SUM('Fact table test'[TOTAL_ACTIVES])

AVR = AVERAGEX(VALUES('DATE TABLE'[Date]),[act])

[clarafff]

Thx, it is working now 😀