Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi
I have the following columns.
Employee | X1 | X2 | Y |
E1 | 3 | 2 | 2.2 |
E2 | 4 | 4 | 3.1 |
E3 | 1 | 1 | 1.4 |
E4 | 1 | 1 | 1.6 |
E5 | 3 | 2 | 2.4 |
E6 | 3 | 1 | 3.8 |
I want to find two different correlations (X1,Y) and (X2,Y). Which I am able to using Power BI's quick measure.
However I want to put the Correlation Values in X-axis and another corresponding Parameter say 'Z Parameter' on Y-axis.
Scatter Plot: X-axis: Correlation with Y
Y-axis: Z Parameter
I am not able to do this, as correlations are different individual MEASURES and I need the correlation values in the below TABLE FORMAT to achieve scatter plot as shown in FIGURE 1
Ideal Table Format
Correlation with Y | Z Parameter | |
X1 | 0.61 | 56.44% |
X2 | 0.53 | 57.43% |
FIGURE 1
Currently I am able to achieve this using Excel. However I would like to be able to do this on Power BI itself.
Is there a way for me to get the CORRELATION QUICK measures in a calculated column?
I appreciate all the help I can get.
"Is there a way for me to get measures into a calculated column? "
That is fundamentally unsupported, unfortunately.
User | Count |
---|---|
12 | |
11 | |
8 | |
7 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |