Conditional Filter Arguments in CALCULATE

[kappasig504]

Is there a way to do something like this? I only want the TREATAS filter argument to evaluate if a condition evaluates to true, otherwise I'd like the CALCULATE function to ignore the TREATAS filter argument entirely. 

=CALCULATE(
     [Some Measure],
     IF(

          [Some Table Is Filtered],

          TREATAS(

                  VALUES(Some Table[Column]),

                  'Other Table'[Column]
         )

    )

)

[Anonymous]

Hi @kappasig504 ,

Please try the following expression where [Some Table Is Filtered] needs to return true or false depending on your data writing.

VAR IsFiltered = [Some Table Is Filtered]
VAR Result = 
IF(
    IsFiltered,
    CALCULATE(
        [Some Measure],
        TREATAS(
            VALUES(Some Table[Column]),
            'Other Table'[Column]
        )
    ),
   CALCULATE( [Some Measure])
)
RETURN
Result

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.