Forum Discussion

Uzi2019's avatar
Uzi2019
Community Champion
5 years ago

Getting incorrect total

Hi, I have created measure which is showing correct value row wise.  AA= average(comm)* [days] measure day= no of days in a month Aa is showing incorrect total. I want sum of Aa column in t...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Uzi2019 , Try like

 

sumx(Values(Table[Month]),average(Table[comm])* [days])

Uzi2019's avatar
Uzi2019
Community Champion
5 years ago

amitchandak  thank you for your reply. I resolved issue by my own it was the mistake in average part.

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago
    Thanks Uzi2019
    Please can you post the DAX you used to solve and mark your reply as the solution so everyone else can learn too and find the solution easily? Thanks!