Conditional VALUES

[Martin_Songstad]

Hi!

To iterate over specific ages takes a lot more time than to iterate over age groups, so I would like to avoid doing that unless age is filtered.

My if isfiltered - solution does not work when i put it inside the sumx-statement. How would you go about doing this?

[johnt75 · Accepted solution]

The problem is that IF returns a scalar value, not a table, and so you can't iterate over the result. I think you'd need to rework the code something like

My Measure =
IF (
    ISFILTERED ( 'Table'[Age] ),
    SUMX ( VALUES ( 'Table'[Age] ), [Calculation] ),
    SUMX ( VALUES ( 'Table'[Age group] ), [Calculation] )
)