Forum Discussion
Post PartisanPOwer bi Table visual gets unfiltered
Hi harshadrokade ,
This behavior is expected because the ISINSCOPE() function is designed for hierarchical contexts like Matrix visuals, not Table visuals. In a table, the column is always considered “in scope,” so your measure always evaluates to TRUE, which can unintentionally alter the filter context and make it seem like the visual is ignoring the Date slicer.
To achieve your requirement without breaking the filtering, you should avoid using ISINSCOPE() here and instead use a function like HASONEVALUE(Salesdata[Customer name]), which works correctly with slicers and respects the existing filter context. This will allow you to add the Yes/No column while keeping the table properly filtered by the Date slicer, without needing to create a calculated column.
Hope this helps.
Thank you.
Super UserHi,
Share the download link of the PBI file.
Post PartisanSir, Uortunatory I cant uplaod the file due to access issues.
I have Sales data table having Date(Quarter end dates), Customer and Sales amount columns
I am having Date table with dates (Quarter end dates)
And I have created a table visual with these columns. I want a measure that will show Yes/No based on check if I used Customer column in the table visual. The given measure unfilters the data in table.