Power Bi measure for interpolating values
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.
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.