cancel
Showing results for
Did you mean:
Highlighted
Member

## 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]))
1 ACCEPTED SOLUTION

Accepted Solutions
New Contributor

## Re: DAX formula error / help

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 2
New Contributor

## Re: DAX formula error / help

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.

Member

## Re: DAX formula error / help

mnay thanks mariusz.....let me test and come back appricated thefeedback