Forum Discussion

InsightSeeker's avatar
InsightSeeker
Icon for Helper III rankHelper III
2 years ago
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.   ...
Need Help
Show and Tell
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    InsightSeeker 

    Measure 2 =
    SUMX(
        VALUES('date'[Column1]),
        SUM('value'[value])/12)
       

     

     

     

     

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
InsightSeeker
Icon for Helper III rankHelper III
2 years ago

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

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion
    2 years ago

    InsightSeeker 

     

    could you please sample data  with the ouput you want . 

  • InsightSeeker's avatar
    InsightSeeker
    Icon for Helper III rankHelper III
    2 years ago

    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's avatar
      Daniel29195
      Icon for Community Champion rankCommunity Champion
      2 years ago

      InsightSeeker 

      Measure 2 =
      SUMX(
          VALUES('date'[Column1]),
          SUM('value'[value])/12)