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.