DAX formula error / help

[Anonymous]

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

[Mariusz · Accepted solution]

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.

[Anonymous]

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