Forum Discussion
combine multiple expression into one CALCULATE function
Dear Community, I want to show AVERAGE and STANDARD DEVIATION, based on below measure I can show AVG, but when i am trying to add STDV, got error, (A function 'STDEV.S' has been used in a True/False ...
Hi Anonymous ,
You can also try this:
MeasureStdvY = VAR Avg_ = CALCULATE ( AVERAGE ( 'wash M'[Y] ), ALLEXCEPT ( 'S', 'S'[C], 'S'[S], 'S'[L] ) ) VAR Stdev_ = CALCULATE ( STDEV.S ( 'wash M'[Y] ), ALLEXCEPT ( 'S', 'S'[C], 'S'[S], 'S'[L] ) ) RETURN IF ( ISINSCOPE ( 'M'[D] ), SUM ( 'M'[Y] ), Avg_ & ", " & Stdev_ )Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
You can only display one value per column, unless you present them as text with something like:
[MeasureAvgY] & "-" & [MeasureStdvY]
Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.
Contact me privately for assistance with any large-scale BI needs, tutoring, etc.
Bless you