Forum Discussion
Chanleakna123
6 years agoPost Prodigy
Sum Row in table with Measure
hi all , I have done my Measure with Avg Rolling 90 days , and found out the Sum in Row is not turning corrected. how to make it right ?
Chanleakna123
6 years agoPost Prodigy
amitchandak
6 years agoSuper User
This should work like
sumx(summarize(customer,customer[customer_name],"_avg",[Avg rolling 90 days]),[_avg])
calculate(sumx(table,[Avg rolling 90 days]),values(customer[customer_name]))
But because it rolling time formula, It might not. But try
We basically need a row context to sum up data
- Chanleakna1236 years agoPost Prodigy
hi , the calcuation seem to lost sth . i can't proceed this.
can you help plz