Forum Discussion

TubedData's avatar
TubedData
New Member
2 years ago

Hide data in visual when filter is not used

Hi all. I am currently trying to add a measure to a table visualization that hides data when a filter is not used. I have attempted to use many different functions including ISFILTERED, HASONEVALUE, ...
Need Help
Erokor's avatar
Erokor
Icon for Resolver II rankResolver II
2 years ago

I'm not entirely sure why you have INT() surrounding the ISFILTERED() function, but I don't think it should impact much. The many to many relationship could be the culprit due to underlying functionality and the Blank Row portion that is created. Either way, having a many-to-many relationship isn't going to help you long term.

As a work around, you may be able to do a check using Variables by comparing the countrows of the table/column when filters are stripped from the column: 

Check = 
VAR _CountDropFilter = CALCULATE(
          COUNT('Table'[Column]), REMOVEFILTERS('Table'[Column])
         )
VAR _CountCurr = COUNT('Table'[Column])
VAR _Check = _CountDropFilter = _CountCurr
RETURN
IF(_Check = TRUE(),"Not Fitlered", "Filtered")