Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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/Ch...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    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.

Mariusz's avatar
Mariusz
Community Champion
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

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