Power Bi measure for interpolating values

Job ID: 32821580

Budget: €8 – €30 EUR

Hi,

I need a measure that calculates (interpolates) missing values based on the result of precalculated measures to show in a visual.
Based on this calculation (https://community.powerbi.com/t5/Community-Blog/Linear-Interpolation-with-Power-BI/ba-p/341202).
I already created a measure that will calculate 6 values:
1st that calculates the Average [xx],
2nd that calculates the Average of aboveAverage [xx],
3rd that calculates the Average of belowAverage [xx].

VAR x_AVERAGE = SUMMARIZE ( ALLSELECTED ( Balken ), Balken[STF-Art], Balken[STF-Gehalt], Balken[Werk/ Standort], "xx", AVERAGE ( Balken[fcm,cube,28d N/mm²] ), "xm", AVERAGE ( Balken[maßg ffcflk, L1] ))
VAR x_TotalAVG = AVERAGEX ( x_AVERAGE, [xx] )
VAR x_AboveAVG = AVERAGEX ( FILTER ( x_AVERAGE, [xx] > x_TotalAVG ), [xx] )
VAR x_BelowAVG = AVERAGEX ( FILTER ( x_AVERAGE, [xx] < x_TotalAVG ), [xx] )

Same for [xm].
VAR xm_TotalAVG = AVERAGEX ( x_AVERAGE, [xm] )
VAR xm_AboveAVG = AVERAGEX ( FILTER ( x_AVERAGE, [xm] > xm_TotalAVG ), [xm] )
VAR xm_BelowAVG = AVERAGEX ( FILTER ( x_AVERAGE, [xm] < xm_TotalAVG ), [xm] )

Now I need these as coordinate pairs in an interpolation calculation like in the provided link.

AboveAverage [xx],[xm]
x
requested measure to interpolatedValues
x
Average [xx],[xm]
x
requested measure to interpolatedValues
x
BelowAverage [xx],[xm]

The attached picture shows the calculated values in a table visual.
Related categories: Power BI Microsoft PowerBI