Forum Discussion
Conditional filter within calculate function?
Yeah, I think you can refactor it to combine FilterA and IgnoreA like this:
Test = VAR A = CALCULATE ( [...] ) VAR B = CALCULATE ( [...] ) VAR C = CALCULATE ( [...] ) VAR D = CALCULATE ( [...] ) VAR FilterA = FILTER ( fact, IF ( ISEMPTY ( A ), NOT fact[A] IN A, fact[A] IN A ) ) VAR FilterB = FILTER ( fact, IF ( ISEMPTY ( B ), NOT fact[B] IN B, fact[B] IN B ) ) VAR FilterC = FILTER ( fact, IF ( ISEMPTY ( C ), NOT fact[C] IN C, fact[C] IN C ) ) VAR FilterD = FILTER ( fact, IF ( ISEMPTY ( D ), NOT fact[D] IN D, fact[D] IN D ) ) RETURN CALCULATE ( [Delta-P], FilterA, FilterB, FilterC, FilterD )
goncalogeraldes This does get rid of that error. Thank you!
The next level of complexity would be having 2 conditions within that calculate function. Is that a possibility using the same switch function logic?
The IF function can't output tables, only single values, but you could rewrite this more like
SWITCH (
TRUE (),
ISEMPTY ( A ) && ISEMPTY ( B ), CALCULATE ( [Delta-P], IgnoreA, IgnoreB ),
ISEMPTY ( A ) && NOT ISEMPTY ( B ), CALCULATE ( [Delta-P], IgnoreA, FilterB ),
NOT ISEMPTY ( A ) && ISEMPTY ( B ), CALCULATE ( [Delta-P], FilterA, IgnoreB ),
NOT ISEMPTY ( A ) && NOT ISEMPTY ( B ), CALCULATE ( [Delta-P], FilterA, FilterB )
)AlexisOlson This worked, thank you!
I have 4 different tables it is referencing, A,B,C, and D. Your example is showing A and B. Due to this, I needed to have 16 of those scenarios listed out in my code. I'm afraid of it getting out of control if I need to add any more tables. Are you familiar with a more concise way to handle this or is the code you provided the only solution?
Yeah, I think you can refactor it to combine FilterA and IgnoreA like this:
Test = VAR A = CALCULATE ( [...] ) VAR B = CALCULATE ( [...] ) VAR C = CALCULATE ( [...] ) VAR D = CALCULATE ( [...] ) VAR FilterA = FILTER ( fact, IF ( ISEMPTY ( A ), NOT fact[A] IN A, fact[A] IN A ) ) VAR FilterB = FILTER ( fact, IF ( ISEMPTY ( B ), NOT fact[B] IN B, fact[B] IN B ) ) VAR FilterC = FILTER ( fact, IF ( ISEMPTY ( C ), NOT fact[C] IN C, fact[C] IN C ) ) VAR FilterD = FILTER ( fact, IF ( ISEMPTY ( D ), NOT fact[D] IN D, fact[D] IN D ) ) RETURN CALCULATE ( [Delta-P], FilterA, FilterB, FilterC, FilterD )AlexisOlson This is exactly what I was looking for! Thank you so much!