Forum Discussion
DAX formula error / help
Hi Experts
I cannot see the wood for the trees, not sure what i am doing wrong here.......
this is what i am trying to establish..
as a guide...
?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'
Report Filter = IF(ISFILTERED('DIM Sales Person'[Office Location]),[Report URL]&"?filter=" & "DIM Sales Person" & " eq " &"'" & SELECTEDVALUE('DIM Sales Person'[Office Location]) & "'"
&"and"&
IF(ISFILTERED('DIM Sales Person'[City])& "DIM Sales Person" & " eq " &"'" & SELECTEDVALUE('DIM Sales Person'[City]) & "'",[Report URL]))Hi Anonymous
You probobly need something like this
Report Filter = VAR oL = "DIM Sales Person/Office Location eq '" & SELECTEDVALUE( 'DIM Sales Person'[Office Location] ) & "'" VAR oC = "DIM Sales Person/City eq '" & SELECTEDVALUE( Table3[Result] ) & "'" RETURN [Report URL] & SWITCH( TRUE, ISFILTERED( 'DIM Sales Person'[Office Location] ) && ISFILTERED( 'DIM Sales Person'[City] ), "?filter=" & oL & " and " & oC, ISFILTERED( 'DIM Sales Person'[Office Location] ), "?filter=" & oL, ISFILTERED( 'DIM Sales Person'[City] ), "?filter=" & oC )Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous
You probobly need something like this
Report Filter = VAR oL = "DIM Sales Person/Office Location eq '" & SELECTEDVALUE( 'DIM Sales Person'[Office Location] ) & "'" VAR oC = "DIM Sales Person/City eq '" & SELECTEDVALUE( Table3[Result] ) & "'" RETURN [Report URL] & SWITCH( TRUE, ISFILTERED( 'DIM Sales Person'[Office Location] ) && ISFILTERED( 'DIM Sales Person'[City] ), "?filter=" & oL & " and " & oC, ISFILTERED( 'DIM Sales Person'[Office Location] ), "?filter=" & oL, ISFILTERED( 'DIM Sales Person'[City] ), "?filter=" & oC )Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.