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 when i put it inside the sumx-statement. How would you go about doing this?

 

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

1 Reply

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