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 sum up the covariance measure to show 1x1 value so that it can fit on a card visual (look at images below), may I know how it can be done? Any help is much appreciated 🙂

 

i.e., Sum up all the values in covariance values in the matrix

So that the summed value can be shown in the card visual

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.

     

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      The sample file has been uploaded here

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        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.