Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Summing a measure

Hi,    I have followed the guidance raised in this post to create a measure that calculates the covariance using the volatility and correlation tables.    If for some apparent reason I need to su...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Try this measure

    Measure = SUMX(GENERATE(ALL('rows'[id]),ALL('columns'[id])),[covariance])

    Hope this helps.

     

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

What is a 1x1 value? The value in the card alreay appears to be the total of individual cells in your matrix.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

The value of 2.38% is hardcoded (as a measure). I wish to sum up the values in the matrix using a measure to get that value at the end of the day.