Forum Discussion
Filter table by Measure not working
G'Day,
The solution you have attempted is based on the technique described in the Show/Hide Excelerator BI Blog post.
The issue you are having is that your logic is testing a column that is being used in the table visual you are attempting to hide. Therefore, it is selffulfilling the Check_Filter_CoCode requirement.
If you need this column in the visual, then you will need to use a duplicate proxy column in the slicer.
For example, if this is a column being used in a relationship, you could use ISFILTERED('table'[PD_CO_CODE]), but then in the visual plot 'fact tble'[PD_CO_CODE]
Alternatively, you could possibly use a SELECTEDVALUE measure on your table visual, then the value will only appear in the visual when a single selection in the slicer has been made.
It depends if you were intending to force single selection on the slicer.
Hope this helps, and Good luck!
G'Day,
The solution you have attempted is based on the technique described in the Show/Hide Excelerator BI Blog post.
The issue you are having is that your logic is testing a column that is being used in the table visual you are attempting to hide. Therefore, it is selffulfilling the Check_Filter_CoCode requirement.
If you need this column in the visual, then you will need to use a duplicate proxy column in the slicer.
For example, if this is a column being used in a relationship, you could use ISFILTERED('table'[PD_CO_CODE]), but then in the visual plot 'fact tble'[PD_CO_CODE]
Alternatively, you could possibly use a SELECTEDVALUE measure on your table visual, then the value will only appear in the visual when a single selection in the slicer has been made.
It depends if you were intending to force single selection on the slicer.
Hope this helps, and Good luck!
Sorry, I'm green hand , I wonder know how to use the selectedvalue measure on this table visual so it will only appear in the visual when a single selection in the slicer has been made,Thank you so much🙏