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 coun...
Need Help
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])
  • clarafff's avatar
    clarafff
    Frequent Visitor
    3 years ago

    Thx, it is working now ğŸ˜€