Forum Discussion
Using EXCEPT with ALLEXCEPT and ALLSELECTED
Hi I'm trying to use EXCEPT with ALLEXCEPT and ALLSELECTED to get the list of values in Column1 have been removed by a filter (i.e. the values not selected) CONCATENATEX( EXCEPT( ALLEXCEPT(...
Hi,
I am doing something similar to this, the difference is that I am trying to calculate an average(frmo a different table) for all of the values not selected. This sis the calculation I am using
Trend Chart Other =
IF (
ISBLANK ( [Avg Result] ),
BLANK (),
CALCULATE (
[Avg Result],
EXCEPT (
ALL ( SurveyQuestionQ11[value], SurveyQuestionQ11[ResponseId] ),
ALLSELECTED ( SurveyQuestionQ11[value],SurveyQuestionQ11[ResponseId])
)
)
)
Avg Result is a measure from another table but has a relationship to SurveyQuestionQ11.
The math is not calcualting correctly and I cannot figure out why.