Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts
I have the following DAX formula which is using a filter within a uRL and the URL dynamically updates based on the filter selection.
How could i amend the code to include an addtional filter office City into the DAX as shown below...
link to part 1 of question
https://community.powerbi.com/t5/Desktop/URLs-Power-Bi-Desktop/m-p/717338/highlight/false#M346191
current dax formula...
Report Filter = IF(ISFILTERED('DIM Sales Person'[Office Location]),[Report URL]&"?filter=" & "DIM Sales Person" & " eq " &"'" & SELECTEDVALUE('DIM Sales Person'[Office Location]) & "'",[Report URL])
Solved! Go to Solution.
Hi @Anonymous ,
You can try following code.
Report URL = "https://msit.powerbi.com/groups/me/reports/xxxxxxx/ReportSection"
Report Filter = IF(AND(ISFILTERED('DIM Sales Person'[Office Location]),ISFILTERED('DIM Sales Person'[office City])),[Report URL]&"?filter=" & "DIM Sales Person/Office Location" & " eq " &"'" & SELECTEDVALUE('DIM Sales Person'[Office Location]) & "'" and "DIM Sales Person/Office City" & " eq " &"'" & SELECTEDVALUE('DIM Sales Person'[Office City]) & "'",[Report URL])
You can refer to the links: https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields ,
https://www.kasperonbi.com/creating-a-hyperlink-with-filters-through-dax/ .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can try following code.
Report URL = "https://msit.powerbi.com/groups/me/reports/xxxxxxx/ReportSection"
Report Filter = IF(AND(ISFILTERED('DIM Sales Person'[Office Location]),ISFILTERED('DIM Sales Person'[office City])),[Report URL]&"?filter=" & "DIM Sales Person/Office Location" & " eq " &"'" & SELECTEDVALUE('DIM Sales Person'[Office Location]) & "'" and "DIM Sales Person/Office City" & " eq " &"'" & SELECTEDVALUE('DIM Sales Person'[Office City]) & "'",[Report URL])
You can refer to the links: https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields ,
https://www.kasperonbi.com/creating-a-hyperlink-with-filters-through-dax/ .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many Thanks Any much appreciated once again excellent feedback as always.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |