- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table Filtering Issues with Web URL Measure
I have a measure like this:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It sounds like the issue you are experiencing may be related to the way the measure is being evaluated in the context of the table and the slicer. When you add the URL measure to the table, it may be causing the table to evaluate the measure in a different context than the slicer, which can result in unexpected behavior.
One possible solution is to modify the measure to use the FILTER function instead of the SELECTEDVALUE function. This will ensure that the measure is evaluated in the same context as the slicer. For example, you could try something like this:
Item Link = VAR SelectedID = SELECTEDVALUE('List Directory'[ID]) VAR SelectedSysID = SELECTEDVALUE('List Directory'[SysID]) RETURN IF(LEFT(SelectedID,3)="ABC", CONCATENATE("https://www.somesite.com/nav_to.do?uri=tablename.do?sys_id=", SelectedSysID), CONCATENATE("https://www.somesite.com/nav_to.do?uri=anothertable.do?sys_id=", SelectedSysID) )
Alternatively, you could try adding the URL measure to the visual as a tooltip instead of as a column in the table. This will allow you to see the URL when you hover over the data points in the table, without affecting the filtering behavior of the slicer.
I hope this helps! Let me know if you have any further questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It sounds like the issue you are experiencing may be related to the way the measure is being evaluated in the context of the table and the slicer. When you add the URL measure to the table, it may be causing the table to evaluate the measure in a different context than the slicer, which can result in unexpected behavior.
One possible solution is to modify the measure to use the FILTER function instead of the SELECTEDVALUE function. This will ensure that the measure is evaluated in the same context as the slicer. For example, you could try something like this:
Item Link = VAR SelectedID = SELECTEDVALUE('List Directory'[ID]) VAR SelectedSysID = SELECTEDVALUE('List Directory'[SysID]) RETURN IF(LEFT(SelectedID,3)="ABC", CONCATENATE("https://www.somesite.com/nav_to.do?uri=tablename.do?sys_id=", SelectedSysID), CONCATENATE("https://www.somesite.com/nav_to.do?uri=anothertable.do?sys_id=", SelectedSysID) )
Alternatively, you could try adding the URL measure to the visual as a tooltip instead of as a column in the table. This will allow you to see the URL when you hover over the data points in the table, without affecting the filtering behavior of the slicer.
I hope this helps! Let me know if you have any further questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, this does appear to work as expected.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @jmfillman,
According to your code, I think your measure will return different result based on different ID. I create a sample to have a test, and I think it should work.
Your issue should be caused by your data model, please share a sample file with me and show me a screenshot with the result you want.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 07-19-2019 03:40 AM | ||
06-10-2024 07:43 AM | |||
07-14-2023 09:23 AM | |||
11-22-2023 09:39 PM | |||
11-13-2023 10:26 AM |
User | Count |
---|---|
12 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
13 | |
6 | |
5 | |
3 | |
2 |