Forum Discussion
Hiding table before filtering
- 5 years ago
Hi, rodriperez10
According to your description, I think you used the wrong function. The isfiltered() function returns TRUE when columnName is being filtered directly. It is generally used to judge whether the data in the slicer has been selected. It doesn't filter the data of the row.
You can create a measure based on the row data you want to filter,Like this:
SGs Filtrados = IF ( table[column] <> BLANK (), 1, 0 )If you still have problems, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, rodriperez10
According to your description, I think you used the wrong function. The isfiltered() function returns TRUE when columnName is being filtered directly. It is generally used to judge whether the data in the slicer has been selected. It doesn't filter the data of the row.
You can create a measure based on the row data you want to filter,Like this:
SGs Filtrados =
IF ( table[column] <> BLANK (), 1, 0 )
If you still have problems, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.