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 ?
amitchandak
6 years agoSuper User
It going to give to Avg. Can you share expected output with some sample data
Chanleakna123
6 years agoPost Prodigy
- amitchandak6 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