Filter on Matrix table

[PaulBoden]

Hi all,

I'm having an issue where a filter doesn't seem applying correctly in my matrix table. I'm a bit stumped as all of the underlying logic seems to be functioning correctly to populate the table with the proper values but the basic [Measure X] is [Value Y]  filter doesn't seem to be working as expected.

I've included a screenshot below by way of example. You'll notice that in the highlighted row, every instance of the #_AvailThresholdFilter field contains '0', yet the row is still being returned when this visual is filter to only include '1'. What I anticipated was that only rows, with at least one field containing a '1' would be returned. 

Any suggestions? Thanks

[v-yiruan-msft]

Hi @PaulBoden ,

If I understand correctly, the visual-level filter with the condition ([#_AvailThresholdFilter] is 1) seems not working in your report. The visual should only display the data which [#_AvailThresholdFilter] is 1, but it return all data with both 0 and 1...

In order to make troubleshooting and give you a suitable solution, could you please provide some raw data in your table (exclude sensitive data) with Text format and the formula of measure [#_AvailThresholdFilter]? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards