Query on Correlation Function

[muha0045]

Hi All, 

I am creating a quick measure of correlation value between X and Y values based on category ID. The values X and Y are set to SUM. 

However the correlation value obtained (0.56) is not the same as the value obtained using excel function CORREL (0.8). Any idea what went wrong? 

Regards, 

Akbar

[Anonymous]

Hi @muha0045,

Can you please share a sample pbix file for test? it will help with troubleshooting.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

It has been created as a measure or column, can you share more details?

[muha0045]

Hi there, 

It has been created as a quick measure. 

I selected quick measure and input the following:

Category = ID (ABC type)

Measure X = X (123 type)

Measure Y = Y (123 type)

Regards, 

Akbar