Forum Discussion
Need help to create a certain meassure.
Is this a measure or a calculated column? I do not quite understand the role of the ALLEXCEPT in your code, I would need more details. Based on that code you could try something like this for the operation itself, and then adapt it with the ALLEXCEPT as needed
VAR median_ = MEDIAN ( Table1[Value] ) VAR N_ = COUNT ( Table1[Value] ) RETURN SQRT ( DIVIDE ( SUMX ( Table1, POWER ( Table1[Value] - median_, 2 ) ), N_ - 1 ) )Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
The formula is
sqrt( sum( x-median(x) )^2 / (n-1) )
with x are the entries of Table1[Value] and n is the number of entries of Table1[Value].
Community ChampionIs this a measure or a calculated column? I do not quite understand the role of the ALLEXCEPT in your code, I would need more details. Based on that code you could try something like this for the operation itself, and then adapt it with the ALLEXCEPT as needed
VAR median_ = MEDIAN ( Table1[Value] )
VAR N_ = COUNT ( Table1[Value] )
RETURN
SQRT (
DIVIDE ( SUMX ( Table1, POWER ( Table1[Value] - median_, 2 ) ), N_ - 1 )
)
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers