cancel
Showing results for
Did you mean:
Post Prodigy

## 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
Super User IV

## 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
Super User IV

## 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.

Post Prodigy

## Re: DAX formula error / help

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

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors