Summing a measure

[cylo]

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

[danextian]

Hi @cylo 

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

[cylo]

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. 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[cylo]

The sample file has been uploaded here

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

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

Hope this helps.

[cylo]

Thanks so much @Ashish_Mathur 🙂

[Ashish_Mathur]

You are welcome.