topic Conditional VALUES in DAX Commands and Tips

Conditional VALUES

Martin_Songstad — Wed, 05 Apr 2023 12:27:45 GMT

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?

Re: Conditional VALUES

johnt75 — Wed, 05 Apr 2023 12:47:04 GMT

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