cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Route217 Member
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
Mariusz New Contributor
New Contributor

Re: DAX formula error / help

Hi @Route217 

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

Re: DAX formula error / help

Hi @Route217 

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.

Route217 Member
Member

Re: DAX formula error / help

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