Conditional Filter Arguments in CALCULATE

kappasig504 — Thu, 11 Apr 2024 16:01:38 GMT

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

)

Re: Conditional Filter Arguments in CALCULATE

Anonymous — Fri, 12 Apr 2024 02:38:32 GMT

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.

topic Re: Conditional Filter Arguments in CALCULATE in DAX Commands and Tips

Conditional Filter Arguments in CALCULATE

Re: Conditional Filter Arguments in CALCULATE