Forum Discussion

Martin_Songstad's avatar
Martin_Songstad
Frequent Visitor
3 years ago
Solved

Conditional VALUES

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 whe...
  • johnt75's avatar
    johnt75
    3 years ago

    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] )
)
johnt75's avatar
johnt75
Super User
3 years ago

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] )
)