Forum Discussion
Solved
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. ...
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.
Hi Daniel29195 - Please see the below screenshot. When I am displaying this measure in Matrix visual, the column "grand total" does not show the correct total amount. How can i have this fixed?