Forum Discussion
Need help with Measure
I have a yearly value in my database, which i need to show it on monthly basis.
I have created a measure as Contracted = SUM(Contracted_Volume_Yearly])/12 to get the result for each month.
Now when i displaying this measure in Matrix visual, the column "grand total" does not show the correct total amount. How can i have this fixed?
| Contracted_Volume_Yearly |
| 1,000,000 |
5 Replies
if we assume that you are using month in the matrix :
use the following pattern :
sumx ( values ( tbl_name[month_col_name] ) , SUM(Contracted_Volume_Yearly])/12 )
let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠:Hi Daniel29195 I tried your suggestion but I am not getting the correct values.
