The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
10 | |
7 |