Forum Discussion

clarafff's avatar
clarafff
Frequent Visitor
3 years ago

why the average function is not working ?

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

 

Need Help

3 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    pls try this

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

AVR = AVERAGEX(VALUES('DATE TABLE'[Date]),[act])
  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    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.