Alternative to TREATAS

[mrclay82]

Hi all,

I have this measure using TREATAS to calculate on a different date column. The problem is that it is beyond slow.

It slows down the whole report.

Are there any alternatives to TREATAS for this purpose that is more efficient?

Please note that the [Received All %] measure works brilliantly and cannot be changed.

CALCULATE(

    [Received All %],

    TREATAS(

        VALUES(

            'Dim - RequiredDate'[Date]

        ),

        'Dim - PromisedDate'[Date]

    )

)

Many thanks in advance!

[tamerj1]

Hi @mrclay82 

the alternative is usually INTERSECT function or IN operator but that wouldn't improve the performance significantly. In order to optimize your code you need to provide more context and more details about your data model and the measure being calculated perhaps we can find a totally different approach.