Forum Discussion
Table Filtering Issues with Web URL Measure
- 3 years ago
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.
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.
- jmfillman3 years ago
Helper I
Thank you, this does appear to work as expected.