Need help with Measure

[InsightSeeker]

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

[Daniel29195]

@InsightSeeker 

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! 🤠:

[InsightSeeker]

Hi @Daniel29195  I tried your suggestion but I am not getting the correct values.

[InsightSeeker]

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?

[Daniel29195 · Accepted solution]

@InsightSeeker 

Measure 2 =

SUMX(

    VALUES('date'[Column1]),

    SUM('value'[value])/12)

[Daniel29195]

@InsightSeeker 

could you please sample data  with the ouput you want .