Table Filtering Issues with Web URL Measure

[jmfillman]

I have a measure like this:

Item Link = if (LEFT(SELECTEDVALUE('List Directory'[ID]),3)="ABC",CONCATENATE("https://www.somesite.com/nav_to.do?uri=tablename.do?sys_id=", SELECTEDVALUE('List Directory'[SysID])),CONCATENATE("https://www.somesite.com/nav_to.do?uri=anothertable.do?sys_id=", SELECTEDVALUE('List Directory'[SysID])))

When I add this Measure to the table, I get unexpected behavior. I have a slicer for the table which works perfectly, when th URL measure is not a column for the table. When I add it to the table, the actual values in the table do not change/filter, with the slicer. What does change, is the table scrollbar size, clearly detecting a change in the number of filtered rows, and the conditional formatting also changes. But not a single row or column of text changes. I can scroll the table, and see all values, i.e. no filter on the visual data.

Removing the Measure field from the table, all works as expected.

[Adamboer · Accepted solution]

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.

[jmfillman]

Thank you, this does appear to work as expected.

[Anonymous]

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.